So I'm working on a .CSV import feature from a lighting control console. Unfortunately, I'm limited in what the CSV looks like when it comes off of the lighting board. Right now I'm getting:
Row 1 - TITLE
Row 2 - COLUMN HEADERS
Row 3+ - DATA
I want to strip that first row from the CSV automatically because obviously when I try to import it right now it looks for field names in row one when they're actually contained in row 2.
I can obviously just delete that first row in excel and then do it, but I'm trying to make it as seamless as possible. Maybe if FileMaker can't do this on its own, I could do something in applescript? Luckily the row one contents are always the same.