Filtering non alphanumeric charaters

kudaka · Post by **kudaka** » Mon Dec 06, 2004 10:00 am

Hello!
How to filter all non-alphanumeric charaters from a srting. (filter space,/,-,* etc).
Is there a option in oconv function for this? or any other transformation function available for this?

Input string:
'SY-002-1|SALINAS-E Boronda Rd/San'
Result:
'SY0021SALINASEBorondaRdSan'

Thank you

chucksmith · Post by **chucksmith** » Mon Dec 06, 2004 11:15 am

Look at the Convert() function

kcbland · Post by **kcbland** » Mon Dec 06, 2004 12:05 pm

CHANGE, EREPLACE, CONVERT

garthmac · Post by **garthmac** » Tue Dec 07, 2004 3:11 am

If you want to use Oconv, create your own routine using:

Ans = Oconv(Arg1, "MCA")

chulett · Post by **chulett** » Tue Dec 07, 2004 8:27 am

No need to do that, there's already a built-in Transform for that - it's called LETTERS. Note that there is also what is basically the opposite called DIGITS that uses "MCN".

kudaka · Post by **kudaka** » Wed Dec 08, 2004 6:21 pm

I used convert function. It works. But, we need to list all the unwanted characters.

FYI:
Becuase I need ALPHA and DIGITS (alpha numerics), we can not use the 'MCA' or 'MCN' formats with Oconv. Same with "LETTERS" and "DIGITS" built-in transforms.

thanks for all the help.

rasi · Post by **rasi** » Wed Dec 08, 2004 7:02 pm

Hi

To get the non-alpha and non-numbers use the MCA and MCN function twice.

Oconv(Oconv('String','MC/N'),'MC/A')

Best of luck

Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Dec 08, 2004 7:08 pm

So, to keep all the alphanumerics, use that result and convert to "".

Code: Select all

Convert(Oconv(Oconv(MyString,'MC/N'),'MC/A'), "", MyString)