Another version.. put replacetext(tData,"(?!\n)(\D)",empty)
If there are lines with no numbers at all the list will end up with some empties, but those can easily be filtered out after the replacetext. This replaces everything except the newline and digits ( \d matches a digit, \D matches all non-digits. (?!\n) is a NOT match to the newline. In my example, order matters, the \n check needs to be first) On Wed, Jun 11, 2014 at 12:50 PM, Alain Farmer <alain_far...@yahoo.com> wrote: > Use replaceText: > put replaceText ( yourData, "^[0-9]*", empty) into yourData > > > On Wednesday, June 11, 2014 2:25:11 PM, Magicgate Software - Skip Kimpel < > s...@magicgate.com> wrote: > > > > Hello LC'ers > > I have data element that I need to scan for all NON numbers and remove > them. For instance this data element should read 0123456789 but sometimes > is listed as 0123-4-5678-9 or has foreign characters in it or reads NOT > AVAILABLE. > > so: > if item 14 of tLine <> number then.... > > There are about 500,000 rows of data to go through so my dilemma is to > make the code as efficient as possible. > > Thank you for any input you might have! > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
