Exporting Data Problem with Line Breaks...

[sladewilson]

I have a Yahoo Store and am using Access Database with a table of product data. In this table there is a column where the data contains line breaks... Example:

Color Red Blue Grey

Size Small Medium Large

How do I export this data without the line breaks throwing off the fields in a CSV file?

 

[Remou]

You do not say why you are exporting the data, there may be other ways round. I do not think you can create a CSV file from data with line breaks. You will need a query with Replace, for example, that changes the line breaks to something else, "<BR>" may be suitable.

 

[sladewilson]

I am exporting from Access to CSV so I can upload the product database to my Yahoo Store. Everything works great until I add options to products (due to the line breaks on the rows that contain items with options).

 

[Remou]

If you create a query and enter this:
[tt]Expr1: replace([FieldName],(Chr(13)+Chr(10)),"<BR>")[/tt]
For each field that has a line break, you can use the query to export to a CSV. I have use BR as it seems likely that the CSV output will be used with HTML.