on 04-17-2009 4:32 AM
Hi
I am using Sender Adapter FTP. There is a header title in the file.
Can you please let me know if there is any way to ignore the same.
Sample file
Customer Number,Amount,Payment Reference,Date,Discount to,Invoice Number,External Reference,Amount,State,Reason Code
9100011,1900,REMIT55001,04.04.09,9100011,AA123776863,11901860,100,NSW,80
9100011,1900,REMIT55001,04.04.09,9100011,AA123776864,11901861,150,NSW,80
9100011,1900,REMIT55001,04.04.09,9100011,AA123776867,11901862,-250,NSW,80
9100011,1900,REMIT55001,04.04.09,9100011,AA123776865,11901863,200,NSW,80
9100011,1900,REMIT55001,04.04.09,9100011,,CL11901864,-300,VIC,
9100011,1900,REMIT55001,04.04.09,9100011,,CL11901940,2000,ADL,
Regards
Ria
Hi,
In File Content Conversion....
Under Document Offset, specify the number of lines that are to be ignored at the beginning of the document.
This enables you to skip comment lines or column names during processing. If you do not make an entry, the default value is zero lines
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Refer this link...check for document offset:
http://help.sap.com/saphelp_nw70/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm
Regards,
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use Content conversion and specify the number of lines that are to be ignored at the beginning of the document in Document Offset field.
Regards,
Lim...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ria,
Use Document Offset as 1 to ignore the first line.
Thanks,
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.