TrimSpacesAndTabs ( text )

trims leading/trailing spaces and tabs

Average rating: 4.4 (32 votes) Log in to vote

Joe Rovang - Show more from this author

Sample input:

TrimSpacesAndTabs ( Char ( 9 ) & "sample text " )

Sample output:

"sample text"

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

// This function removes leading/trailing spaces and tabs while leaving all other spacing intact.

Let (
[
	tabChar = Char ( 9 );
	textScrubbed = Substitute ( text;
		[ " "; "" ];
		[ tabChar; "" ]
	);
	firstChar = Left ( textScrubbed; 1 );
	firstCharPos = Position ( text; firstChar; 1; 1 );
	lastChar = Right ( textScrubbed; 1 );
	lastCharPos = Position ( text; lastChar; Length ( text ); -1 )
];

If ( not IsEmpty ( textScrubbed );
	Middle ( text; firstCharPos; lastCharPos - firstCharPos + 1 )
)

)

This function is an enhanced version of the native Trim() function; it trims not only leading/trailing spaces, but tabs as well.

Comments

		Eric, SJSU May 22, 2015
Appreciate having this worked out. :-) Went through the logic, and it makes sense to me - find non-space non-tab endpoints and extract middle of string based on those. Haven't looked at edge cases yet. Had to add a closing paren for the If statement to get custom function to save. Working fine in my particular application now. Many Thanks!

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

TrimSpacesAndTabs ( text )

Comments

Support this website.

Support this website.