Brian Dunning's FileMaker Custom Functions

ListColumnValue ( Value ; NumberOfColumn ; ColumnSeparator ; RowSeparator )

Get return-separated value of specified column in Value. Like List function for multi-column array.

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

Koji Takeuchi   Koji Takeuchi
TonicNote, Inc.
https://tonic-note.com

Share on Facebook Share on Twitter

  Sample input:
ListColumnValue ( "George Harrison¶John Lennon¶Paul McCartney¶Ringo Starr" ; 2 ; " " ; ¶ )
  Sample output:
"Harrison¶Lennon¶McCartney¶Starr"

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

ListColumnValue ( Value ; NumberOfColumn ; ColumnSeparator ; RowSeparator )
2012.09.22, Koji Takeuchi


description:
Get return-separated value of specified column in Value.
Like List function for multi-column array.
ex1.
$$Array = "George Harrison¶John Lennon¶Paul McCartney¶Ringo Starr"

ListColumnValue ( $$Array ; 2 ; " " ; ¶ )
= "Harrison¶Lennon¶McCartney¶Starr"
ex2.
$$Array = "George,Harrison,Lead Guitar,Gretch¶John,Lennon,Rhythm Guitar,Rickenbacker¶Paul,McCartney,Bass,Hofner¶Ringo,Starr,Drums,Ladwig"

ListColumnValue ( $$Array ; 3 ; "," ; ¶ )
= "Lead Guitar¶Rhythm Guitar¶Bass¶Drums"
ex3.
$$Array = "George,Harrison,Lead Guitar,Gretch¶John,Lennon,Rhythm Guitar,Rickenbacker¶Paul,McCartney,Bass,Hofner¶Ringo,Starr,Drums,Ladwig"

ListColumnValue ( $$Array ; 3 ; "" ; "" )
= "Lead Guitar¶Rhythm Guitar¶Bass¶Drums"
// If you don't specify ColumnSeparator or RowSeparator, "," and "¶" are used by default.

 

Comments

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.