Using of Trim function in parallel jobs

[karthegx]

Hi,

I have Problem regarding the usage of Trim function. I am getting input data of a particular column as RA|D|IU|S . I used Trim function in server job as Trim(columnname,"|","A") its working and result was RADIUS.To get output like this what function i want to use in parallel.

Thanks in Advance

[DSguru2B]

Use Convert()

Code: Select all

Convert("|","", columnname)