How to filter the records which contains special chars

ds@tcs · Post by **ds@tcs** » Thu Mar 24, 2011 3:42 am

I have source data like

colname
-----------
aaaaaa
bbb*bb
ccc/ccc
ddd+dd
eeeeee

out put should be like

col1        col2
----        ---------
aaaaaa      bbb*bb
eeeeee      ccc/ccc
            ddd+dd

means the records which contains special characters need to send in different column

can any bodyhelp in this

vinothkumar · Post by **vinothkumar** » Thu Mar 24, 2011 7:52 am

Use convert/index function to find whether the input contains any special characters.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 24, 2011 1:35 pm

Using IsAlpha() might be easier.

ds@tcs · Post by **ds@tcs** » Fri Mar 25, 2011 2:31 am

ray.wurlod wrote:Using IsAlpha() might be easier. ...

Can u explain in clear

nareshketepalli · Post by **nareshketepalli** » Fri Mar 25, 2011 3:45 am

In transformer stage we have a fuction like

Alpha(colname).

Write the above function in constraints.so u can get ur output.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Fri Mar 25, 2011 11:52 am

DSXchange is not a mobile phone. Will you please stop using SMS-style abbreviations?!

Yes, the function is Alpha(), not IsAlpha(). It returns a true/false value depending on whethe the string consists wholly of alphabetic characters.