Importing multiple Excel values into checkboxes

[tigergirl]

Hello all,

I have an Excel spreadsheet that has a field with multiple values from a survey (ie - a,b,d,f,g,j). I need to import those values into a checkbox field in FMP. When I do the import, only those records with a single entry (ie - : show up checked properly, although if I change the field type to standard data entry, all the information shows up. Is there some way I need to separate out the information prior to (or after) the import?

Thanks for your help!

[Vaughan]

Multiple entries in a checkbox-formatted field are separated by pargraphs. From your description the imported data is comma separated. You could run a Replace command over the field and specify a calculation that Substitutes a paragraph for comma character.

[tigergirl]

Thanks Vaughan! That's perfect!

I appreciate your help,

Tiger