list_of_breaks ( integer ; _list )

Returns a defined number of pilcrows for delimited graph data

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

Petter Derhaag
The Next Organization
http://www.thenextorganization.com

Sample input:

list_of_breaks(5 ; "")

Sample output:

¶¶¶¶¶

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

//© Petter Derhaag - May 3d 2016
//Creating an 'empty' list of breaks to ensure a correct graph representation when using delimited data.
//Recursive Function

Let(
	[
	start = integer;
	current = ValueCount(_list)
	];

	Case(
		start - current = 1 or integer = 1 ; 
		_list ; 
		list_of_breaks(start ; _list & ¶) 
		) // end casae

	) // end let

To make sure that my 'delimited data' filemaker graphs are shown correctly I want the possibility to make a 'list' of empty values. Because the List function always include a number of additional breaks, I created this recursive function.

Just enter the number of 'rows' you want and it is returned.

© - Petter Derhaag May 2015

Comments

		comment, VR May 3, 2016
Compare: http://www.briandunning.com/cf/942

		Petter, Bussum May 4, 2016
Does indeed seem to exactly what I want. Does this mean I should remove this one? Happy to do so, don't know what the normal way of things is here.

		Petter, Bussum May 4, 2016
Testing the Repeat function (http://www.briandunning.com/cf/942) - does work, however it also does end up with one break too many. Repeat(Â¶ ; 5) results in a list with 6 'rows'.

		comment, VR May 5, 2016
I am not sure what you mean by "rows". Repeat ( Â¶ ; 5 ) returns 5 carriage returns. And ValueCount ( Repeat ( Â¶ ; 5 ) ) returns 5.

		Petter, Bussum May 6, 2016
By comparison, if you use Repeat ( Â¶ & "." ; 5 ); you'll see that the list returns as: << . . . . .>> For my purposes, the second row is where the '.' starts. This means there is one 'row' too many.

		comment, VR May 6, 2016
Well, if you want 5 values of ".", you ought to be using Repeat ( "." & Â¶ ; 5 ). What you have returns one empty value, followed by 5 values of "." each. Note that a FileMaker list of values may or may not be terminated by a carriage return - it makes no diffference to value count.

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

list_of_breaks ( integer ; _list )

Comments

Support this website.

Support this website.