MVSFORUMS.com

[agredell]

I have data where the users put double quotes around a character field. I am selecting the data fields to their full lengths, and want to strip data like this:

User entered a 40 byte char field as:

"COOK, MIDDLE"

and padded (not varchar) out to 40 bytes. Since the full field is 40 bytes, and terminated by spaces, the function STRIP(FIELDNAME,B,'"') is NOT stripping the latter double-quote. I tried embedding the above strip inside of another strip, as in CHAR(STRIP(STRIP(FIELDNAME,B,'"'),L),40), but the results are the same. Is there a way to strip both the trailing spaces and the ending double quotes, so that the field winds up looking like this:

COOK, MIDDLE

Thanks!
_________________
Alan Gredell

[kolusu]

agredell,


Try this

[agredell]

Many thanks, Kolusu, that worked perfectly!
_________________
Alan Gredell