2 Replies Latest reply on Feb 24, 2010 10:26 AM by kes601

    Separate Imported Field with Commas into Different Fields

    kes601

      Title

      Separate Imported Field with Commas into Different Fields

      Post

      We are using FMP to keep track of enrollments in camps.  Data will be imported from an online form that will be exported as a CSV file.

       

      In the CSV we have fields week1camps, week2camps, week3camps, etc.

       

      In each of these fields you might have 3 camps people have registered for.

       

      So, week1camps might come in as:

      baseball, soccer, basketball

       

      Is there any way I could import the week1camps field and have it add a "Y" into the names of the fields referenced in that field?  As in, in this example a "Y" would be added to a baseball field, soccer field, and basketball field? 

       

      Thanks for any help.