Removing all NON numbers from a data element

Alain Farmer alain_farmer at yahoo.com
Wed Jun 11 20:50:15 CEST 2014


Use replaceText:
put replaceText ( yourData, "^[0-9]*", empty) into yourData


On Wednesday, June 11, 2014 2:25:11 PM, Magicgate Software - Skip Kimpel <skip at 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 at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


More information about the use-livecode mailing list