Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Is there any way to ignore first few fields from first row in .CSV file using FCC in Sender FTP??

E.G.

Partner Code,Partner Name,Partner Type,9/2/2013,,9/3/2013,,9/4/2013,,9/5/2013,,9/6/2013,,9/7/2013,,9/8/2013,

Here,i want to ignore first 3 fields since these are header and values for these fields come from next row.But i want to read dates.

How can i achieve?

Actually my aim is to read below file:

Partner Code,Partner Name,Partner Type,9/2/2013,,9/3/2013,,9/4/2013,,9/5/2013,,9/6/2013,,9/7/2013,,9/8/2013,

10,ABC,Full Time,7:00,15:00,7:00,15:00,10:00,18:00,10:00,18:00,10:00,18:00,10:00,18:00,,

,,,8.00,,8.00,,8.00,,8.00,,8.00,,8.00,,,

,56,SM,,,,,,,,,,,,,,

12,PQR ,Full Time,10:00,18:00,10:00,18:00,10:00,18:00,6:30,14:30,6:30,14:30,6:30,14:30,0:00,0:00

,,,8.00,,8.00,,8.00,,8.00,,8.00,,8.00,,0.00,

,56,ASM,,,,,,,,,,,,,,

27,XYZ ,Full Time,0:00,0:00,0:00,0:00,0:00,0:00,0:00,0:00,0:00,0:00,0:00,0:00,0:00,0:00

,,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,56,BAR,ML,,ML,,ML,,ML,,ML,,ML,,ML,

It looks like attached file in Excel:

Thank you in advance!!

/Skrishnna S.

Excel.jpg (81965 B)
Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question