AnsweredAssumed Answered

creating a profile for  EDISimpleText

Question asked by gouthamr388096 on Sep 18, 2018
Latest reply on Sep 18, 2018 by gouthamr388096

Hi Folks

 

One of the applications I connect to gives data as EDISimpletext. The first element in each line is a header element and all other element (separated by ^) are child elements in the header. Also one of the elements repeats (COMFLOTA05). I have not been able to create a profile using this document. What would be the best way to create a profile (either flat file or XML).

 

ENV001^^^ESA61961488^^ESB58368069^^180423^0955
COMFLOTA000
COMFLOTA01^1524470147572^COMFLOTA^D^97B^UN^PICAPK
COMFLOTA02^962^1524470147572^55
COMFLOTA03^1804230955
COMFLOTA05^ZMS^IFTMINCSI
COMFLOTA05^ACW^CSI-E170626-2018024573
COMFLOTA05^ZMN^ESB583680693
COMFLOTA13

 

If XML, this is how it should be for example.

<XML>

<COMFLOTA13>

<ENV001>

<Receiver>ESA61961488</Receiver>

<Sender>ESB58368069</Sender>

<Date>180423</Date>

</ENV001>

...............

...........

...............

<COMFLOTA05>

<locationquialifier>ZMS</locationquialifier>

<locationvalue>IFTMINCSI </locationvalue>

</COMFLOTA05>

<COMFLOTA05>

<locationquialifier>ACW</locationquialifier>

<locationvalue>CSI-E170626-2018024573</locationvalue>

</COMFLOTA05>

<COMFLOTA05>

<locationquialifier>ZMN</locationquialifier>

<locationvalue>ESB583680693</locationvalue>

</COMFLOTA05>

 

</COMFLOTA13>

</XML>

Outcomes