Brian Dunning's FileMaker Custom Functions

CSV_readField ( string ; value )

get's the N-th value in a csv

  Average rating: 4.8 (20 votes) Log in to vote

Bert Kraan   Bert Kraan
Allied Pea's
http://buffel.org

Share on Facebook Share on Twitter

  Sample input:
Example CSV: "Header";"";"2015";"";"";"Chess";"";"";"no";....

If [ CSV_readField ( imported::string ; 1 ) = "Header" ]
Go to Record ....

or

Set Variable [ $Game ; Value:CSV_readField ( imported::string ; 6 )]
  Sample output:


true




$Game gets set to "Chess"

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

We get a csv from another system which needs to be "read"/interpreted and imported into filemaker. Importing is easy using filemaker's "Import Records" script step. After that :

The function enables me to read fields of which I know they contain information so I can put the values in filemaker.

I know which (N-th) field contains the information per the csv definition.

 

Comments

unix   unix, Japan
Jan 4, 2016
I wonder why do you say the "semi-colon separated value" as CSV.
 
Bert Kraan   Bert Kraan, Apeldoorn
Jan 5, 2016
In Europe we use the comma as a decimal separator, and it is custom to separate CSV's using a semicolon.

Otherwise differentiating between which comma is a decimal separator and wich is a field separator would be a real challenge.

(http://www.digitalpreservation.gov/formats/fdd/fdd000323.shtml)
 
unix   unix, Japan
Jan 6, 2016
Thanks!
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.