Kirk, One trick for counting the number of characters is : $n:=length($text) $text:=replace string($text;$char;"") $n:=$n-length($text)
That will work for your text file. Excel is more complicated. If it's .xls it's basically XML. Miyako made a component for working with them that may work for you. Check out his github site. You may be able to just parse the XML too, I haven't ever tried so can't say for sure. On Wed, Nov 8, 2017 at 5:42 PM, rooftop99--- via 4D_Tech < [email protected]> wrote: > What is the most efficient way to count the number of occurrences of a > specific character in a large document? Specifically, What are you doing > to count Excel rows (or CR delimited text files) in a similar scenario? > -- Kirk Brooks San Francisco, CA ======================= *The only thing necessary for the triumph of evil is for good men to do nothing.* *- Edmund Burke* ********************************************************************** 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] **********************************************************************
