AnsweredAssumed Answered

Working with CSV Files

Question asked by dblackmon on Dec 10, 2013
Latest reply on Dec 11, 2013 by philmodjunk


Working with CSV Files


     I have a CSV file that is generated by another program that I wish to automate the importing process. 


     My issues is the CSV contains two sets of data that belonged within two different tables, with each having there own headers.  The first set of data is the first two lines in the CSV file which will not change, with a space dividing the second set of data. From there it will always be around 30 to 40 lines of information needing to be imported within a different table. Is there a way to script an import routine to read the individual lines in the CSV or is there a better way to automate this process within Filemaker.

     I have been using the product for less than a year so I am hoping there is an easy way to preform this feat or engineering.


     I have included a small sample of the data being collected to help describe what i am trying to achieve.


                    Start Time                     Track                     Series                     Hosted Session Name
                    2013.12.10 12:39 AM GMT                     Atlanta Motor Speedway - Oval                     Hosted iRacing                     NOBULLMOTORSPORT  Nationwide  Series
     <!--StartFragment-->                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              <!--EndFragment-->      
                    Fin Pos                     Car ID                     Car                     Car Class ID                     Car Class                     Custid                     Driver                     Start Pos                     Car #                     Out ID                     Out                     Interval                     Laps Led                     Average Lap Time                     Fastest Lap Time                     Fast Lap#                     Laps Comp                     Inc                     Club ID                     Club                     Session Name
                    1                     38                     Chevrolet Impala Class B                     0                     Hosted All Cars Class                     88499                     James Ray                     2                     0                     0                     Running                     0                     33                     48.218                     29.859                     60                     80                     0                     22                     Florida                     NOBULLMOTORSPORT  Nationwide  Series
                    2                     51                     Ford Mustang Class B                     0                     Hosted All Cars Class                     111941                     Chuck Sweeting                     29                     62                     0                     Running                     -0.479                     12                     48.224                     29.905                     77                     80                     4                     22                     Florida                     NOBULLMOTORSPORT  Nationwide  Series
                    3                     38                     Chevrolet Impala Class B                     0                     Hosted All Cars Class                     80955                     Kevin Carr                     20                     3                     0                     Running                     -0.958                     0                     48.23                     29.964                     68                     80                     0                     16                     Pennsylvania                     NOBULLMOTORSPORT  Nationwide  Series