DSXchange

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

Look at the Convert() function

CHANGE, EREPLACE, CONVERT

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

Ans = Oconv(Arg1, "MCA")

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".

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.

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

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