a cheat.. you will create 2 copies of the data. $Start_size := length(Imported_Text) $Removed:=replace string(Imported_Text;Char(13)) $Removed_Size:=$Start_Size - Length($Removed)
$Removed_Size = number of characters (returns) replaced > Thank you Cannon, > > Progress indicator is not the only reason we need to know number of > rows in advance. However, your suggestion for using parse position > and file size for process bars is intriguing and new to me. I will > investigate. > > Kirk > >> On Nov 8, 2017, at 7:11 PM, Cannon Smith via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> If the only reason you need to know the number of rows beforehand is >> to help in showing a progress indicator, you could use the file size >> and current parse position instead.... >> >> -- >> Cannon Smith >> >>> On Nov 8, 2017, at 6:42 PM, rooftop99--- via 4D_Tech >>> <4d_tech@lists.4d.com> wrote: >>> >>> We are working with large Excel documents which contain upwards of >>> 750K rows and we need to import each row into a 4D application to >>> create records. In advance of the import process I would like to >>> know how may rows to expect. >> >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4d.com/archives.html >> Options: http://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ------------ Hell is other people Jean-Paul Sartre ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
