DSXchange

Posted: **Fri Mar 08, 2013 12:08 am**

Hi,

I need to trim the first few characters ina column

Ex:
i/p

109-87654567

o/p

87654567

I tried to use trim function it didn't worked.Can anyone post some ideas to acheive this.

Regards
kumar

Posted: **Fri Mar 08, 2013 12:11 am**

Code: Select all

Right(InLink.TheColumn, Len(InLink.TheColumn) - 4)

Posted: **Fri Mar 08, 2013 12:21 am**

You could also substring from position 5 to the end of the string.

Posted: **Fri Mar 08, 2013 12:34 am**

Thank you Ray That worked.

Regards
Kumar

DSXchange

Trim the first characters

Trim the first characters