TrimN ( text ; hitlist )

Removes any of a string of defined characters from leading/trailing positions on the supplied text

Average rating: 4.6 (36 votes) Log in to vote

Ray Cologon - Show more from this author
NightWing Enterprises
http://www.nightwing.com.au/FileMaker

Sample input:

TrimN ( " * Smile for the camera!¶" , "*!?.,: ¶" )

Sample output:

Smile for the camera

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

Let([
C1 = PatternCount(hitList; Left(text; 1));
Cn = PatternCount(hitList; Right(text; 1));
Ca = C1 + Cn];
If(Ca;
TrimN(Middle(text; 1 + C1; Length(text) - Ca); hitList);
Text)
)

This function allows you to define the characters which are to be trimmed from the supplied text on the fly. Thus you can selectively remove bullets, asterisks, elypses or other punctuation as well as leading/trailing numbers or whitespace.

There is no length limit on the hitlist, so the function can be used to selkectively strip a number of unwanted leading/trailing characters in one call.

Comments

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

TrimN ( text ; hitlist )

Comments

Support this website.

Support this website.