AnsweredAssumed Answered

Is there a way to strip the first row of a CSV?

Question asked by MikeWood on Nov 12, 2015
Latest reply on Sep 8, 2016 by MikeWood

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.

 

Any ideas?

Outcomes