Originally posted by: SystemAdmin

I am trying to remove leading and trailing quotes from a field.

In the past I have done something like this to remove data:

=TRIMRIGHT(In_Field) - to remove spaces

=TRIMRIGHT(In_Field,"123") - removes 123
However, in this case I want to remove quotes.
Obviously this does not work: =TRIMRIGHT(In_Field," b:2cc0634d19"[/b:2cc0634d19] "),

because it thinks you are closing the previous quotes. I've tried using the Hex value, but still no luck.

Any thoughts ?

Thanks
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Please try this:

=TRIMRIGHT(In_Field,SYMBOL(34))
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

why not use
RIGHT(LEFT(IN_FIELD,(SIZE(IN_FIELD) - 1)),SIZE(IN_FIELD) - 2)
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

=TRIMRIGHT(In_Field,SYMBOL(34))

• That was exactly what I was looking for, thanks.

• John

#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Try SUBSTITUTE(Fieldname(",""))
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

trim(trim(DSLink14.explanation,char(13),"A"),char(10),"A")
this removes carrage returns and newlines from a text field you could use

trim(DSLink14.explanation,char(34),"A")
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender