Originally posted by: Jaango

Hi,
Can anyone tell me how to strip of the rfh header part, using WTX. So my input will be having a RFH string followed by a proper xml. The RFH string can contain null values and all. The rfh string ends with, </abc> then a space. I need to take the substring after "</abc> then a space", from the whole input, which makes the output data.

So I am looking for

substring after(whole input which contains rfh header and followed by xml,</abc> then a space)

Please let me know how to do this.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: repanzer1

The WORD function allows for on the fly delimiting, so if you want everything after the first "</abc>", you can use it to grab it, but. if there's another instance of "</abc>" in the file, it will grab everything between the first one and the second one. There are many ways you could achieve this, but I would use WORD if possible.

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: JGibby

You could try trimming the header away.

TRIMLEFT( InputVariable ,WORD(InputVariable,
"</abc> ",1) + 
"</abc> " )

This will strip off everything to the left of "</abc> " and the "</abc> " also. If there is another "</abc> " in the string, it will still be there.

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

Originally posted by: Jaango

Thanks for your inputs
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender