Skip to Content
0

LINE DELETION IN CSV FILE IN SAP HCI

Mar 10, 2017 at 07:37 PM

69

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hi,

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

Share
10 |10000 characters needed characters left characters exceeded