hi,

i am very new to filemaker, can you please hep guys.

i am importing an excel file which has some comma seperated values in one cell that goes into a checkbox set in fm8.

but i cannot manage it, the checkbox set does not understand commas.

for example the cell contains:

America, UK, Germany, Italy

and the checkbox set has the same values as a custom list

How can i import the data to checkbox set and display the values checked?

A checkbox is merely a formatting option for a text field. The actual values contained in the field are return-separated. So, after the import, run a loop [or Replace] to set the field with

Substitute( yourField; ", "; ¶ )

thanks for the quick reply but how can i run this command?

sorry for that it may be very easy but i dont know how to do that?

Click in your field. Then press Ctrl + = (or go to the records menu and select replace field contents)

Choose replace with calculated result and then put in Substitute( yourField; ", "; ¶ ) where your field is your field

~Genx

thanks again...

btw i've found something, i wrote the command to the scriptmaker and it does it to all records.

but it does not stop i think..

is this a wrong way to run the substitute command?

I'm sorry? You mean you put it in a loop?

Likely the reason it didn't exit the loop is because you didn't specify an exit condition i.e. Exit Loop If.

If you did this in script maker, it should have been structured as one of the following:

Loop

Set Field [yourField ; Substitute(yourField; ", "; ¶ )

Go to Record [Next ; Exit after Last] **Note, when specifying, go to record Next or previous, there is an "Exit After Last" option which is ticked in this case.

End If

or

Loop

Set Field [yourField ; Substitute(yourField; ", "; ¶ )

Exit Loop If [ Get(RecordNumber) = Get(FoundCount)]

Go to Record [ Next ]

End Loop

~Genx