Skip to Content
0
Former Member
Mar 23, 2009 at 08:41 AM

FCC SplitByValue function

20 Views

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