Originally posted by: SystemAdmin

I'm getting a file with the following terminators

<0D><0D><0A> or CRCRLF

I want to remove the extra CR/0D.

Having problem getting the map to recognize the multiple CR's

I've run the following tests to help determine whats wrong....

Using a text editor I counted the number of
CRLF = 5, 091
CRCR = 3,394
CR = 10,182

Using a map function my counts were (input = textblob no terminators):

countstring (input, "<<0D>>") = 3,394
countstring (input, "<<NL>>") = 0
countstring (input, "<<0A>>") = 1,697
countstring (input, "<<0D>>" + "<<0A>>") = 0

any thoughts?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

You may want to try :

=TEXT(COUNTSTRING(TextIn,"<<0D>><<0D>><<0A>>"))

to count or....

SUBSTITUTE(TextIn,"<<0D>><<0D>><<0A>>","<<0D>><<0A>>")

to substitute.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Believe I tried that and 'seriestotext'. I'll try again.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Thanks,

This worked

TEXT(COUNTSTRING(TextIn,"<<0D>><<0D>><<0A>>"))

This didn't

TEXT(COUNTSTRING(TextIn,"<<0D>>""<<0D>>""<<0A>>"))
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange