Removing all NON numbers from a data element

Mike Bonner bonnmike at gmail.com
Wed Jun 11 15:36:52 EDT 2014


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_farmer at 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 <
> 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
> _______________________________________________
> 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