FormatList( TheList ; Adjust ; LenX )
Rate this function: Average rating: 3.5 (13 votes)
Discuss this Custom Function
Therese Telepski, Art + Promotion
http://www.art-promo.de
Format of every element of a given List
Sample Input:
| FormatList( "1¶13¶145" ; "r" ; 3 ) |
|
Sample Output:
__1¶
_12¶
145
(The underscores are blanks in real output. In HTML here pure blanks are truncated, whereas or & are shown as is.)
|
|
Description:
Based on 'AddConstantToListValues' by Simon Plint.
Sometimes it may be useful to apply some formatting to every element of a list; e.g. if you want to convert it into a formatted one line text string where every element is represented as an equidistant item. E.g. think of an attendance sheet for a recurring event like sports training etc., where the number of attendants may vary from 5 to 50.
The function adds white spaces to every element of the list, either right or left hand according to parameter 'Adjust', till the total length of that element reaches LenX.
Of course the blank spaces can be replaced by underscores or an arbitrary character given as a fourth parameter if needed and wanted.
The function is called recursively till the whole list is worked down.
To convert it to a single line just add a command like the following after applying the above format:
Substitute ( FormattedList ; "¶" ; Separator )
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. |
CountWordOccurrences ( text ; searchWord ) |
| |
(Tue, Feb 07, 11:15am) |
| 2. |
indonesian_date(date) |
| |
(Mon, Feb 06, 7:14pm) |
| 3. |
phpArrayValue ( array ; key ; pos ) |
| |
(Fri, Jan 27, 1:49pm) |
| 4. |
solfm_timeToMinutes (theTime;roundSec) |
| |
(Fri, Jan 20, 6:26am) |
| 5. |
filterLines(filterField;filterValue;Result) |
| |
(Sat, Jan 14, 2:20pm) |
| 6. |
getMaxValue ( theList ) |
| |
(Thu, Jan 12, 1:06pm) |
| 7. |
MiddleWordsIncPunct ( text ; startingWord ; numberOfWords ) |
| |
(Sat, Jan 07, 9:16am) |
| 8. |
WindowInfo |
| |
(Fri, Jan 06, 12:39pm) |
 |
|
There is something wrong with your Custom Function.
The edit box doesn't want to accept Bündig =, and breaks there.
Is this a Function that we should have already.
Lee Smith, Woodland
June 21, 2010 12:50pm