DSXchange

Posted: **Fri Oct 28, 2011 12:35 am**

Hi,

I have my source record as

abc|"1234|"xyz|"1|"|"
xyz|"3244|"342|"|"|"

I have Strip |" at the end of each record.

How I can accomplish removing quote characters...

I tried with trim function and mentioned |" as delimiter field but it was not working...

Please help me in solving this.. Thanks in advance.......

Posted: **Fri Oct 28, 2011 12:52 am**

Hi,
As | is your delimiter, Try using Convert function (Trim(Convert('"','',colname)),hope it will solve the pbm.

Regards
Ravi

Posted: **Fri Oct 28, 2011 1:54 am**

my output should for the corresponding inputs should be

abc|"1234|"xyz|"1|"|" --- abc|"1234|"xyz|"1
xyz|"3244|"342|"|"|" --- xyz|"3244|"342

Posted: **Fri Oct 28, 2011 3:52 am**

So... you only want to remove the double quote from "blank" fields?

Posted: **Fri Oct 28, 2011 7:28 am**

only right side... empty fields needs to be trimmed

DSXchange

Strip double quotes at end of the record

Strip double quotes at end of the record