Brian Dunning's FileMaker Custom Functions

ColumnWrap ( Text ; StartRow ; NofRows )

Non recursive custom function for colum break after a certain amount of linebreaks

  Average rating: 4.2 (39 votes) Log in to vote

Martin D. Brunner   Martin D. Brunner
Zurich Financial Services
http://www.mdb.bz

Share on Facebook Share on Twitter

  Sample input:
Wrapped text with linebreaks at each end of line:

Lorem ipsum dolor sit
amet, consectetuer
adipiscing elit, sed
diam nonummy nibh
euismod tincidunt ut
laoreet dolore magna
aliquam erat volutpat.
  Sample output:
Text split into colums of specifyed number of rows.

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

Non recursive custom function for colum break after a certain amount of linebreaks.

I needed this functionality to break text that is in one field into multiple colums on apage (i.e. 3 colums, each 52 lines high).

Requires the text to be formated with line breaks, for example with the CF "LineWrap" that can be found on www.brinandunnings.com

Martin D. Brunner, www.mdb.bz

 

Comments

comment   comment, earth
Apr 3, 2009
Try the MiddleValues() function.
 

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: