TrimSpaceCR ( )
Function stats
Average user rating
Support
FileMaker 7.0 +
Date posted
12 December 2009
Version
1
Recursive function
Yes
Function overview
Prototype
TrimSpaceCR (
text )
Parameters
text
Description
Tags: Text Parsing
remove any leading and trailing " " or "¶"
as an extension of FM function Trim(text)
Examples
Sample input
"
the text
"
the text
"
Sample output
"the text"
Function code
//remove any leading and trailing " " or "¶"
//as an extension of Trim(text)
Let([
Text = Trim ( Text );
Text = If ( Left ( Text ; 1 ) = "¶" ; Right ( Text ; Length ( text ) - 1 ) ; Text );
Text = If ( Right ( Text ; 1 ) = "¶" ; Left ( Text ; Length ( text ) - 1 ) ; Text );
Text = Trim ( Text );
r = Right ( Text ; 1 ) = "¶" or Left ( Text ; 1 ) = "¶" ];
If ( r ; TrimSpaceCR (Text) ; Text ) //recursion!
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/237
Prototype: TrimSpaceCR( text )
Function Author: konrad (http://www.fmfunctions.com/mid/224)
Last updated: 12 December 2009
Version: 1
*/
// ===================================
//as an extension of Trim(text)
Let([
Text = Trim ( Text );
Text = If ( Left ( Text ; 1 ) = "¶" ; Right ( Text ; Length ( text ) - 1 ) ; Text );
Text = If ( Right ( Text ; 1 ) = "¶" ; Left ( Text ; Length ( text ) - 1 ) ; Text );
Text = Trim ( Text );
r = Right ( Text ; 1 ) = "¶" or Left ( Text ; 1 ) = "¶" ];
If ( r ; TrimSpaceCR (Text) ; Text ) //recursion!
)
// ===================================
/*
This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/237
Prototype: TrimSpaceCR( text )
Function Author: konrad (http://www.fmfunctions.com/mid/224)
Last updated: 12 December 2009
Version: 1
*/
// ===================================
Login or register to comment
Create a new account with fmcustomfunctions.com or login to post a comment.
Related Functions
