LINE DELETION IN CSV FILE IN SAP HCI

[Former Member]

Hi Experts,

I have CSV file in the source with many records, after splitting , i am converting each line to xml and load it into the SFSF.But the problem is at the end of the file i am getting the line like "------------------------------------------" . So when it comes the CSV_TO_XML converter it is failing.

Requirement :- i want to skip or delete the line which has "--------------" so please help me in deleting the line.

Regards,

Vijay

[Former Member]

Hi,

you can use a script to remove the last line having "--------" value, after this you can use csv to xml converter