Removing line from xml file

Myself1 — Fri, 15 Nov 2024 21:30:33 GMT

Hi,

Here's an example of XML files that my job is generating

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

<time_slots>

<time_slot>

<Field name="tsid">1</Field>

<Field name="tsname">07-09</Field>

<Field name="tslabel">07-09</Field>

<Field name="tsstatus">inactive</Field>

<Field name="tstime_from">07:00:00</Field>

<Field name="tstime_to">09:00:00</Field>

</time_slot>

<time_slot>

<Field name="tsid">2</Field>

<Field name="tsname">08-12h30</Field>

<Field name="tslabel">080000130000</Field>

<Field name="tsstatus">active</Field>

<Field name="tstime_from">08:00:00</Field>

<Field name="tstime_to">12:30:00</Field>

</time_slot>

</time_slots>

I would like to remove the first line <?xml version="1.0" encoding="UTF-8"?>, to be able to concat several XML files, how to do that ?

Regards,

Re: Removing line from xml file

Anonymous — Wed, 09 Aug 2023 07:29:19 GMT

@JC JC after generating the XML file, read the file line by line using tFileInputFullRow, set the header as 1 to skip the first line, re-generate the file using tFileOutputDelimited.

Re: Removing line from xml file

Myself1 — Wed, 09 Aug 2023 08:28:11 GMT

So simple !

Thanks

topic Re: Removing line from xml file in Talend Studio

Removing line from xml file

Re: Removing line from xml file

Re: Removing line from xml file