Remove chars from a string to get only the numbers

garak

Last night i must from a string eleminate all chars (like 'Ak;%') that are not a number (like 7 2 3 5 0).

I was to lazy to solved this with a "loop" (for i = 1 to strlen(TextVariable)).
So i taked a look into the systemvariables of type sting.
I know that delchr() is very powerful. So the solution was very easy:

a -> Textvariable <-- the base
b -> Textvariable <-- the numbers

a := '{a4"B567/0?r45-'; //from this string i need only the numbers
b := DELCHR(a,'=',DELCHR(a,'=','1234567890')); //now, "b" contains only 4567045

Regards

Jonathan2708

Very neat, I like little tips like this.

Good for returning bank sort codes/credit card nos. etc.

Jonathan

Savatage

kriki mentioned such a similar code in 2006
viewtopic.php?t=14879

I've used it many times to clean up phone numbers & zip code, etc.
very useful

garak

#-o 2 years to late :oops:

ssmukhi

9 years later but still THANKS!!!

rcverbeek

Nice