Maybe this will help: http://kb.4d.com/assetid=76822
// UTIL_HowMany C_TEXT($1) // input C_TEXT($2) // count this C_LONGINT($0) If (Count parameters=2) $0:=(Length($1)-(Length(Replace string($1;$2;""))))/Length($2) Else $0:=0 End if Once the project method is saved as UTIL_HowMany it can be used like this: $a:="test, test, test" $b:="," $num:=UTIL_HowMany($a;$b) ________________________________ From: 4D_Tech <[email protected]> on behalf of Chip Scheide via 4D_Tech <[email protected]> Sent: Wednesday, November 8, 2017 9:17:02 PM To: [email protected] Cc: Chip Scheide Subject: Re: Counting occurrences of specific characters In a document 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 >> <[email protected]> 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 >>> <[email protected]> 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:[email protected] >> ********************************************************************** > > ********************************************************************** > 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:[email protected] > ********************************************************************** ------------ 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:[email protected] ********************************************************************** ********************************************************************** 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:[email protected] **********************************************************************
