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|
|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|