Alpha numeric

[murali]

Hi
I need to extract only alpha numeric from the input string
for example 'as df is xx #$ 90:' is the string and i need to extract
'as df is xx 90' in the out put ,can any one help me in coding this.
Thanks in advance

[kcbland]

Look at the OCONV function in your DS BASIC manual, the token MCP removes unprintable characters. There's other options to remove not letters and numeric values. You could also use EREPLACE, CHANGE, and CONVERT to name the specific values to be replaced or removed.

[murali]

Hi kcbland
i have used the oconv function and MCP as token i did not get the result
can u pls code it and show me ,amy be my syantax was wrong
thankyou

[chulett]

You might want to try using the LETTERS transform that is available under the Built-in/String category. Handles the syntax for you.

[sun rays]

You might want to try using the LETTERS transform that is available under the Built-in/String category. Handles the syntax for you.

LETTERS Transform would stip off the numeric characters too.

[ArndW]

The 'MCA' conversion will return just the alphabetic part, the 'MCN' will do just the numeric but there is no conversion for alphanumeric only. I can do a MATCHES on that pattern, but couldn't get a way to have that answer returned.

You could use the following routine I just clobbered together:

ReturnAlphanumeric(Arg1)

Code: Select all

WorkString = UPCASE(Arg1) ;** makes comparison easier
StringLen  = LEN(WorkString)
Ans        = ''
FOR Index = 1 TO StringLen
   TestChar = WorkString[Index,1]
   IF TestChar < 'A' OR TestChar > 'Z'
   THEN
      IF TestChar = ' ' OR (TestChar => '0' AND TestChar <= '9') THEN Ans := Arg1[Index,1]
   END
   ELSE Ans := Arg1[Index,1]
NEXT I

[kcbland]

If you put this in a function it would work great also:

Code: Select all

Ans = Arg1
CONVERT "`!@#$%^&*()_+~-=;:,./<>?\|'" TO "" IN Ans
CONVERT '"' TO "" IN Ans

I hope you get the idea. :D

[chulett]

You might want to try using the LETTERS transform that is available under the Built-in/String category. Handles the syntax for you.

LETTERS Transform would stip off the numeric characters too.

True. Missed the 'numeric' part of the 'alpha numeric' question... doh!

[ArndW]

I though about doing the CONVERT, especially since it is more efficient than a user-written routine; but thought that it might contain more than just the standard non-alphanumeric characters. If the poster knows what characters might be in the data then a CONVERT is better, if it might be any string then the posted code, or possibly a CONVERT in combination with a conversion using 'MCP'.