Export to CSV

[kevinpkelly]

I have a text field in a table that breaks the “export resultset” option in version 3.11. The nature of this field is that it contains Double quotes and commas, like the following line for example …

Hello ” Kevin, Peter” , how are you?

I am probably using an incorrect selection of options when creating the output in csv format, by I can't seem to find the correct selection to make this specific case work.

By default, the nature of a csv file means that

my lines should be terminated by n or rn

my fields terminated by ,

and my fields enclosed by “

I am not sure what “Escaped By” means, but nothing I enter seems to work.

A standard CSV export shouldn't be this hard :wacko:

Can anyone help please.

Thanks

Kevin

[Shadow]

First of all, if you have commas in your fields, then “fields terminated by” option should not be “,”, unless you specify “fields enclosed by”. Secondly, before updating your text fields, you should check for special characters such as “, and have them escaped.

For example,

Quote:

Hello ” Kevin, Peter” , how are you?

should be entered as 'Hello ” Kevin, Peter” , how are you?' . In this case “” is the escape character.

[Author]

Posts