Skip to Content
avatar image
Former Member

LINE DELETION IN CSV FILE IN SAP HCI

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 13, 2017 at 05:47 AM

    Hi,

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

    Add comment
    10|10000 characters needed characters exceeded