csv.getColumn ( array ; returnColumn ; delimiter )

Get designated column from delimited array

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

Bruce Robertson - Show more from this author

Sample input:

csv.getColumn( "a;b;c¶1;2;3"; 2;";")

Sample output:

b
2

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

/*
csv.getColumn( array; returnColumn; delimiter)

Returns designated column from array
Bruce Robertson, Concise Design
Based on csv.getValue concept by Nicolas Bourré

v 1.0 1/25/2011
*/

Case( IsEmpty( array); "";
Let (
[
   vc= ValueCount( array); 
   r = GetValue (array; 1);
   delim = Case (not IsEmpty(delimiter); delimiter; ";");
   rowAsList = Substitute( r; delim; ¶);
   thisMatch = GetValue( rowAsList; returnColumn);
   more = RightValues( array; vc-1)
];
  List( thisMatch ; csv.getcolumn( more; returnColumn; delim ) )
))

Gets return delimited list of values in designated column of a delimited array of values.

Comments

		Muhammad, UK Feb 20, 2017
Hello, Can you kindly explain how this functions works please. For some reason I cannot get it to work.

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

csv.getColumn ( array ; returnColumn ; delimiter )

Comments

Support this website.

Support this website.