filter strings from number

[rafidwh]

Hi All,
If I have a colunm where its values is char(number+string) how can i filter only char

suppose my value is "11A234"
"2E4567"

I want to get the output as A and E only

Is there any logic other than the Datastage inbuit functions to handle this

Thanks in advance

Saik.

[ArndW]

Since DataStage BASIC is a programming language the answer to your question is "yes, there are ways of doing this via programming other than using one of the inbuilt functions such as ICONV(string,'MCA').". I don't know why you would wish to write your own program code to do this, though.

[kumar_s]

This can be easily acheived by CONVERT() function in datastage. But not sure what are you trying to do with "other than the Datastage inbuit functions "

[ray.wurlod]

You can write your own, but it will never be as fast as the inbuilt functions.

Code: Select all

FUNCTION StripNonAlphas(TheString)
Ans = ""
CharCount = Len(TheString)
For ch = 1 To CharCount
   Character = TheString[ch,1]
   If Alpha(Character) Then Ans := Character
Next ch
RETURN(Ans)

Are you perhaps planning to come back and bill for tuning the system after an inefficient initial design?

[DSguru2B]

Or, you can also use the builtin transform funtion LETTERS(). That will return you all the alphabets from a mixed character string. That is offcourse, if you want to utilize the built-in functions of datastage.