GetNthRow ( fieldlist , N , delim )

Get multiple fields for Nth record

Average rating: 4.5 (30 votes) Log in to vote

Bruce Robertson - Show more from this author

Sample input:

GetNthRow("Items::ProductID ¶ Items::Description ¶ Items::ExtdPrice", 3," ")

Sample output:

P101 Widget 39.50

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

//GetNthRow( fieldlist , N , delim)

Let ([
rc = ValueCount(fieldList); 
whichField = LeftWords(LeftValues(fieldList;1);99);
remainder = MiddleValues(fieldList;2;99)
];
Case(RC<2;
GetNthRecord(Evaluate(whichfield);n);
GetNthRecord(Evaluate(whichfield);n) & delim & 
GetNthRow(remainder;n; delim)
))

Requires FileMaker 8. The existing getNthRecord() function only returns a value for one field. The getNthRow function returns values for any number of fields, where field names are submitted as a return separated list.

Comments

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

GetNthRow ( fieldlist , N , delim )

Comments

Support this website.

Support this website.