on 08-30-2006 3:42 PM
Hello all,
We're unable to up-load supplier catalogs using CSV2.0 format when text fields in the file contain any of the following characters: comma, semi-colon, apostrophe, quote (, ; ). While we can get around this by excluding these characters from text fields in the file, the fact is that these characters are generally present across the customers material master description and purchase order texts in the material masters. Apostrophes and quotes are especially numerous because they are common abbreviations for foot and inch respectively.
Has anyone encountered this problem and was able to include these characters in the CSV2.0 file upload?
Thanks in advance for your help!
Frank Heisner
Hello Frank,
I often use the separator "|" or Tab(not visible).
SAP CATALOG CSV 2.0 <|>
Regards,
Masa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Frank: you should have no problems with comma (,) and semi-colon ( - as long as these are not defined as the CSV separator. Not sure about apostrophe ('). Quote (") is a special case for CSV. Per <a href="http://help.sap.com/saphelp_ccm20/helpdata/en/e1/eddebb4b63453cbf209027e0816b8c/content.htm">SAP CSV 2.0 specification</a>, you should be aware that:
<i>If the column value contains one or more double quotes, you must place double quotes around the entire content of the column, and each double quote contained in the value must be doubled.</i>
Cheers,
Serguei
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Serguei,
Thank you for your comments and the link. I agree that quote (") and (') are problems. I've been to
www.creativyst.com/Doc/Articles/CSV/CSV01.htm#CSVariations
and used the the CSV to XML Converter Form link to the latest converter, and tried various suggestions from there (including double quotes), but still not successful when uploading to CCM.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.