AnsweredAssumed Answered

data parsing/cleaning

Question asked by gisguy on Aug 9, 2017
Latest reply on Aug 10, 2017 by gisguy

Hello,

I am a novice to FileMaker, with my background in GIS.

 

 

I've inherited a FileMaker database where one table has three fields as such:

 

record_id          project_code               project_id

1234               12589, 17058                  257842

1235               11387, 25871                  358740

 

I need to restructure the above to this ideal:

record_id          project_code                  project_id

1234                 12589                              257842

1236                 17058                              257842

1235                 11387                              358740

1237                  25871                             358740

 

record is a serial auto entered number and project relates to a different table. table contains ~45000 records.

 

Looking through help, some script seems appropriate. My struggle is where to begin......can anyone please point me in the best direction?

 

Thanks,  Mike

Outcomes