Removing a charecter from the first position of the value

[ravi_etl]

Hi All,

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


"12345678


Thanks

[fareeda_b]

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

[ArndW]

Code: Select all

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

will remove the first character.

Code: Select all

TRIM(In.Column,'"')

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

[nagarjuna]

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