ColumnWrap ( Text ; StartRow ; NofRows )
Rate this function: Average rating: 3.0 (7 votes)
Discuss this Custom Function
Martin D. Brunner, Zurich Financial Services
http://www.mdb.bz
Non recursive custom function for colum break after a certain amount of linebreaks
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. |
|
Description:
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
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:
|
Newest Custom Functions:
| 1. |
GroupRelationInfo ( FileTarget ; TableTarget ; Result ) |
| |
(Tue, Mar 16, 5:57am) |
| 2. |
GeoBox(latitude;longitude; radius) |
| |
(Mon, Mar 15, 11:04am) |
| 3. |
MonthNameList ( start; number; short ) |
| |
(Sun, Mar 14, 11:45pm) |
| 4. |
matchListAB( ListA ; ListB; match_Value; match_operator ; getN ) |
| |
(Sun, Mar 14, 10:29pm) |
| 5. |
Bin2Hex ( binary ) |
| |
(Sat, Mar 13, 10:08pm) |
| 6. |
SlideView (text) |
| |
(Sat, Mar 13, 8:40pm) |
| 7. |
HashFNV1a64 ( text ; empty ) |
| |
(Sat, Mar 13, 6:23pm) |
| 8. |
HashFNV1a32 ( text ; empty ) |
| |
(Sat, Mar 13, 5:55pm) |
 |
|
Try the MiddleValues() function.
comment, earth
April 03, 2009 11:50pm