Conversion of single record with multiple lines to XML

[Former Member]

Hi All,

In my scenario, I need to convert a multiple line record (text format) to a single recordset (XML format).

My outbound structure follows

Header

|

-- Data1

-- Data2

Input file:

Fir

st second

-

---

Output Expected:

<header>

<Data>First second<\Data>

<\header>

But when I tried I got the error "Set the param lastfield optional". The problem is whenever it encounters a new line it assumes that's the end of the record. But my input record comes in multiple lines.

How do I solve it?

Thanks,

Ajay.

[STALANKI]

did u specify any endsepereature?

try using enclosuresign option to skip nl withing fields.

[Former Member]

Hi Jitesh,

But will I get the output as I expected??... I've already tried that and that's not what I expected..

Thanks,

Ajay.

[Former Member]

Hi

just give

recordstructurename.lastFieldsOptional YES

this might solve ur problem

regards

jithesh