New line in csv file how???!!

[liltbrockie]

Ok I need to export some info from filemaker and import it into a ecommerce app.

This is an example for you in its simplest form 2 fields: a model and a description

Model Description

XYZ1 1.this is a very good model thatblah

2.blah blah it does all sorts of things

3.also good for this is a very good model

4.good for sports too

Now when I export as a csv or tab .. the description sits all on one line... i need there to be line breaks on it.

How do I format the description text so that the description does not sit all on one line???

At the moment im just getting:

1.this is a very good model thatblah2.blah blah it does all sorts of things3.also good for this is a very good model4.good for sports too

..when i import it into my ecommerce app :-(

[TheTominator]

1) Export using XML and use an XSLT stylesheet that creates text in exactly the format you need.

or

2) Post-process the CSV file using a program you create to convert the vertical tab characters (used as the line breaks in text fields) into line feeds or carriage returns. As long as your CSV columns are properly quoted, line breaks may work for your input.

or

3) Create a table with one text field. Using a script manually generate the exact individual lines you want in your output file as data in this text field with one line per record. Export these records as a tab delimited file.

or

4) Create a script that generates all of your exact output as one big block of text in a global text field. Export field contents into a file. Note that this will be a UTF-16 encoded text file. Many older programs have trouble with this encoding.