Import into Value List not working

[janet K]

Hi Everyone.

I am stuck on something and I have been working on this all morning and I am not able to solve my problem so I thought I would throw it out there to a few others that use filemaker.

I am looking to import a .dat file that has been given to me into filemaker. I have a few fields that have a valuelist. I want it to check off mulitiple values in a valuelist. The only way to do that is to have a data field that checks off all of the items it needs to is to have a return after each item which makes your data look like this:

04 Fall

05 Spring

My Data file looks like this, all in one field:

04 Fall, 05 Spring

I cant replace my comma's within that field either before I import them because it messes up the import. I would do it after I imported but I cant seem to do a find on a comma in that field I am getting the error "There is no valid criteria in this request. Type a valid request."

Has anyone else had success importing into a field with a value list where you want it to check off more then one value? If so how did you do it?

Suggestions? Does this make sense to anyone...it is driving me nuts.

Thanks

Janet

[-Queue-]

Once you've run your import, run a Set Field loop or Replace step to Substitute( field, ", ", "

[janet K]

Thank you!!! That worked Great!