Brian Dunning's FileMaker Custom Functions

CommaToList ( commaValues )

Converts comma separated values to standard list with values separated by return

  Be the first to rate this function Log in to vote

Lazarus Sismanis   Lazarus Sismanis - Show more from this author
Decision Group
http://www.decisiongroup.net

Share on Facebook Share on Twitter

  Sample input:
CommaToList ( "Value One, Value Two, Value Three" )
  Sample output:
Value One
Value Two
Value Three

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

Converts comma separated values to standard Filemaker value list with values separated by return ( ¶ ). Makes input more readable when passing value lists to other calculations, fields or custom functions.

 

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: