General discussion

Locked

I need a CSV file

By Navjun ·
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.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

I need a CSV file

by DKlippert In reply to I need a CSV file

Procedure to Export a Text File with Both Comma and Quote Delimiters 213448

http://tinyurl.com/372g


Or look for Text Write on this site:

http://www.tushar-mehta.com/

Collapse -

I need a CSV file

by Navjun In reply to I need a CSV file

Poster rated this answer

Collapse -

I need a CSV file

by ptaylor In reply to I need a CSV file

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.

Collapse -

I need a CSV file

by Navjun In reply to I need a CSV file

Poster rated this answer

Collapse -

I need a CSV file

by Navjun In reply to I need a CSV file

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums