Exporting Field Values

[Monger]

Hi,

Many thanks to those who can help wit this:

I am exporting values which are later read into a MySQL database. I am using a checkbox field to enter different values to a field. THe import script needs to be able to distinguish seperate values by a comma but when I export the values are just seperated by a blank. Since some of the values are two workds, the import script would misinterpret these values even if it seperated values by these blanks.

Is there a way to export this field and the corresponding values and seperate them by commas?

Thanks a lot,

Stephan

[TerenceM]

The results from a checkbox field are stored as a return-delimited ValueList, but when you export the returns are automatically converted to spaces. So I guess my first instinct would be to make a second calculation field, with a substitute ( list ; paragraph symbol ; "," ) function, and export that instead.

-Terence

[Monger]

So I guess my first instinct would be to make a second calculation field, with a substitute ( list ; paragraph symbol ; "," ) function, and export that instead.

-Terence

[Monger]

With working my brian to the max and a lot of attempts I figured this out. Was actually really simple. THanks Terence.

[TerenceM]

Glad you got it figured out.

-Terence