CSV_readField ( string ; value )
get's the N-th value in a csv
Average rating: 4.8 (20 votes) Log in to vote
If [ CSV_readField ( imported::string ; 1 ) = "Header" ]
Go to Record ....
Set Variable [ $Game ; Value:CSV_readField ( imported::string ; 6 )]
$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.
Jan 4, 2016
|I wonder why do you say the "semi-colon separated value" as CSV.|
|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.
Jan 6, 2016
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.