Strip double quotes at end of the record

kiran0435 · Post by **kiran0435** » 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.......

ravireddy25 · Post by **ravireddy25** » 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

kiran0435 · Post by **kiran0435** » 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

suse_dk · Post by **suse_dk** » Fri Oct 28, 2011 3:52 am

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

kiran0435 · Post by **kiran0435** » Fri Oct 28, 2011 7:28 am

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