Brian Dunning's FileMaker Custom Functions

SplitValues ( InputString ; ListSeparator ; ChunkSize )

Transforming a string to a value list or a serial number kind of string

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

Karsten Risseeuw   Karsten Risseeuw - Show more from this author
Kursiv Software

Share on Facebook Share on Twitter

  Sample input:
SplitValues ( "ABCDEFGabcdefg" , "¶" ; 3 )
  Sample output:

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

Use the function to create a value list from a string or to split a string every x-characters.



Lee Smith   Lee Smith
Jun 21, 2016
I think you CF is missing a parameter of SplitValues?
Karsten Risseeuw   Karsten Risseeuw, Kursiv Software
Jun 21, 2016
Hi Lee

This works as a loop. The function is called SplitValues, and you call the same function from within the function. Test it to see it. It works (and if not, drop me a line).

Thomas Hellwig   Thomas Hellwig, Hamburg / Germany
Jun 22, 2016
But the title of this CF is "ListValues ( InputString ; ListSeparator ; ChunkSize )" not "SplitValues ( InputString ; ListSeparator ; ChunkSize )".
Karsten Risseeuw   Karsten Risseeuw, Kursiv Software
Jun 22, 2016
@Thomas: Herzlichen Dank! I had 2 versions. This is my mistake. Corrected now.
@Lee: Sorry – I had overseen my mistake.

Lee Smith   Lee Smith
Jun 22, 2016
That fixed it.

Log in to post comments.


Note: these functions are not guaranteed or supported by 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 15 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:

Under construction. Email me your wish list for improvements.