Skip to Content
0
Former Member
Oct 01, 2009 at 01:39 PM

FCC in SFTP

48 Views

Hi Experts,

Can someone explain how FCC can be performed on this file

HEADER:ABC:XYZ

1234 aJHJS

1245 AJSHJD

7895 WSTA4556

.

.

.

.

4588 AHGSDJ_AHSHA

END

to get this into following structure

<?xml version="1.0" encoding="utf-8"?>

<ns:MT_Source xmlns:ns="Some/address">

<Record>

<Value>HEADER:ABC:XYZ</Value>

</Record>

<Record>

<Value>1234 aJHJS</Value>

</Record>

.

.

.

.

<Record>

<Value>END</Value>

</Record>

where each line of the file is taken into the field 'Value'

Thanks in advance,

Vishal