Hi Friends,
I have requirement where user will provide text file with following pattern of data:
:20:2000000003
:32A:081227SAR10000,00
:50:AL WAHA PETROCHEMICALS
AL-JUBAIL INDUSTRIAL CITY
KSA
:52A:AAALSARI
:53B:/010-049-123-008
:57A:BSFRSARI
:59:/812-8300-270
SAHARA PETRO. (TESTING FOR B2B)
OFFICE NO. 987
45678 AL JUBAIL INDUSTRIAL CITY
:70:INV. 9876543 FR.27.12.08
I need to convert this into xml like:
<?xml version="1.0"?>
<PaymentMessage>
<PaymentTransaction>
<CompanyCode>Corporate code</CompanyCode>
<SequenceNum>0000000000107007</SequenceNum>
<TransactionData>:20:2000000003
:32A:081227SAR10000,00
:50:AL WAHA PETROCHEMICALS
AL-JUBAIL INDUSTRIAL CITY
KSA
:52A:AAALSARI
:53B:/010-049-123-008
:57A:BSFRSARI
:59:/812-8300-270
SAHARA PETRO. (TESTING FOR B2B)
OFFICE NO. 987
45678 AL JUBAIL INDUSTRIAL CITY
:70:INV. 9876543 FR.27.12.08
</TransactionData>
</PaymentTransaction>
</PaymentMessage>
Can this be done using Splitbyvalue function in xi?
or please suggest how can i achieve this in XI