Page 1 of 1

Using of Trim function in parallel jobs

Posted: Fri Apr 27, 2007 5:49 am
by 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

Posted: Fri Apr 27, 2007 7:14 am
by DSguru2B
Use Convert()

Code: Select all

Convert("|","", columnname)