I have an excell file and i need to make a CSV format out of it:
The CSV file should look like this: "12";"1555";"10000";;"101.00";"2002-04-22 17:17:01";NULL;NULL;"1.00";"1";"1";"1";"1" Each value should be enclosed in a unique character (e.g. single or double quote: ' or ") Fields must be separated by a unique character (e.g. comma or semicolon) Lines must be terminated with an enter or newline character. Fields with no value must stay empty: eg ..."01";;"text";"anothertext";;"1"... orthey can be represented by NULL Please notice: 0 (zero) is not an empty value! please help me out thank you
This conversation is currently closed to new comments.
An easy way I have found to create a CSV formatted file is to import into a table in Access. After importing, export the same table and choose Text Files for "Save as Type". When you hit the save button, it will allow you to choose your delimiter for separation of values. Hope this helps.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
I need a CSV file
The CSV file should look like this:
"12";"1555";"10000";;"101.00";"2002-04-22 17:17:01";NULL;NULL;"1.00";"1";"1";"1";"1"
Each value should be enclosed in a unique character (e.g. single or double quote: ' or ")
Fields must be separated by a unique character (e.g. comma or semicolon)
Lines must be terminated with an enter or newline character.
Fields with no value must stay empty: eg ..."01";;"text";"anothertext";;"1"... orthey can be represented by NULL
Please notice: 0 (zero) is not an empty value!
please help me out
thank you