export field with multiple selections in value lis

[concrete]

I have a field with a value list and check boxes to select multiple values from this list.

if I export the file with this field to a tab delimited text file, I get all the selection within that field seperated with a "space".

Is it possible to get a "comma' and a "space" there.

that would make things a lot more understandable.

i hope this is clear...

thx

[BobWeaver]

It's not actually a space that it's putting in. Filemaker puts carriage returns between the multiple items in a checkbox field, but it converts them to vertical tabs when it exports. What you need to do is create a calculated field cChkBoxExport with this formula:

Substitute(TheOriginalField,"

[concrete]

thx bob

you're a life saver

i was fiddling around with the Substitute thing, but i didn't know i had to look for a carriage return

many thx