DSXchange

Posted: **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

Posted: **Thu Mar 24, 2011 7:52 am**

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

Posted: **Thu Mar 24, 2011 1:35 pm**

Using IsAlpha() might be easier.

Posted: **Fri Mar 25, 2011 2:31 am**

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

Can u explain in clear

Posted: **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,

Posted: **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.

DSXchange

How to filter the records which contains special chars

How to filter the records which contains special chars