Page 1 of 1

Trim function

Posted: Thu Oct 24, 2013 10:51 am
by 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

Posted: Thu Oct 24, 2013 11:50 am
by 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.

Posted: Thu Oct 24, 2013 11:57 am
by sriec12
I dont have any spaces here ....double quotes first place and in between or end.

Posted: Thu Oct 24, 2013 12:46 pm
by sriec12
My bad......The function which i am using working fine.