Trim function

[sriec12]

Hello Everyone,

My input data comes like "ASH" or SRI"RAM" when its loading to file ......its loading as ""ASH"" or "SRI"RAM""

I want to trim " (quotes).....


expected output is
--------------------------------

"ASH"
"SRIRAM"

I m using Trim(columnname, ' " ', A) but its not working...Plz guide me

[asorrell]

Do you really have a space before and after the double quotes like your example does?

If so, you should be using '"' (single,double,single), not ' " ' (single, space,double,space,single).

Also - not all quotes are the same character set - insure you are stripping out the correct quotes.

[sriec12]

I dont have any spaces here ....double quotes first place and in between or end.

[sriec12]

My bad......The function which i am using working fine.