Originally posted by: SystemAdmin

Hi All,
I am having a reuirement to handle segmented , fixed format data , which coming out of mq response , by using a wtx ,dpa file.

The input will be coming as shown below,
LL1ZZ1DataPayloadLL2ZZ2DataPayload2..................LLnZZnDataPayloadn

and the output should be like

DataPayload1DataPayLoad2..................DataPayLoadn

i.e. We should strip all LL ZZ fields and copy only payload to output.

If ,if any of you guys can suggest a probable approach for implementing the same, it will be really helpful..
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

One thing I forgot to mention,dat the DataPayLoad length will not be fixed always.
especially for the last segment the data length may vary from 0 to 32K8..

Due to which I am facing issues in implementing this requirement.
Expecting any of your guidance on the same.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: repanzer1

I'm a bit confused. To me is looks like the field seperator in the data is "LLnZZn", where "n" is the index of the field, meaning, it increases by 1 for every field. Is that true? In the example above, there is no number after the first "DataPayLoad", but there is a number after the second one. Can you explain the data a bit better and I'll offer a suggestion?

---

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

Originally posted by: Vino685

Its quite simple , use substitute function to remove these LL ..ZZ..etc and use Leavealpha function to remove these numbers 1,2,3...etc.,
Hope this helps...
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender