Skip to Content
Former Member
Jul 22, 2008 at 02:49 PM

how to handle preceding space characters in file to file(FCC on both sides)


Hi All,

We have scenario with file to file (FCC on both sides).

Issue is: Sender side we are converting source file (CSV) into XML. But while converting it is ignoring preceding spaces.


Suppose Source file(CSV) contains one record as mentioned below ( for ur understanding purpose I mentioned 'X' instead of space. )

XXXXXXXXXX12345 78945 23548 23446

The above record is getting converted into XML as

<text>12345 78945 23548 23446</text>

But we need the record to be converted into XML as mentioned below

<text>XXXXXXXXXX12345 78945 23548 23446</text>

i.e we need spaces before "12345" also.

As both sender and receiver having same structure, we are not using any mapping also.

Please suggest in this regard.

Thanks & Regards,