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
Kursiv Software
http://kursiv-software.com

Share on Facebook Share on Twitter

  Sample input:
SplitValues ( "ABCDEFGabcdefg" , "¶" ; 3 )
  Sample output:
ABC
DEF
Gab
cde
fg

  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.

 

Comments

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).

Regards
Karsten
 
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.

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

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.