DSXchange

Posted: **Tue Jun 09, 2009 10:58 pm**

Hi All,

Can someone tell me how to remove the double quote from the first position of the field value as below

"12345678

Thanks

Posted: **Tue Jun 09, 2009 11:35 pm**

Hi Ravi,
have you tried convert function in transformer ?
try this one
Code:
Convert('"','',column name)

Posted: **Tue Jun 09, 2009 11:55 pm**

RIGHT(In.Column,LEN(In.Column)-1)

will remove the first character.

TRIM(In.Column,'"')

or the convert command as listed above will remove double-quotes from the string.

Posted: **Wed Jun 10, 2009 4:37 am**

If you are getting quotes starting everytime then you can also use substring function

Removing a charecter from the first position of the value