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