RemoveControlCode ( Text )

Remove control codes (ex. VT as in-cell return code of Excel).

Be the first to rate this function Log in to vote

Koji Takeuchi - Show more from this author
TonicNote, Inc.
https://tonicnote.com

Sample input:

RemoveControlCode ( "PastedDirtyTextCopiedOnWord/Excel*NULL*" )

Sample output:

"PastedDirtyTextCopiedOnWord/Excel"

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

/*
RemoveControlCode ( Text )
2020.01.07, Koji Takeuchi <takeuchi@nemoux.com>

description:
	Remove control codes (ex. VT as in-cell return code of Excel).
	

*/

Let (
[
_EDITED =
	Substitute ( 
		Text ;

		// Raw VTs won't blend in unless you import them, but just in case.
		// Leave 9 (Tab) and 13 (CR: newline within a field).
		[ Base64Decode ( "AA==" ) ; "" ] ;	// NULL
		[ Char ( 1 ) ; "" ] ;	// Start of Heading
		[ Char ( 2 ) ; "" ] ;	// Start of Text
		[ Char ( 3 ) ; "" ] ;	// End of Text
		[ Char ( 4 ) ; "" ] ;	// End of Transmission
		[ Char ( 5 ) ; "" ] ;	// Enquiry
		[ Char ( 6 ) ; "" ] ;	// Acknowledge
		[ Char ( 7 ) ; "" ] ;	// Bell
		[ Char ( 8 ) ; "" ] ;	// Backspace
		[ Char ( 10 ) ; "" ] ;	// Line Feed
		[ Char ( 11 ) ; "" ] ;	// Vertical Tab
		[ Char ( 12 ) ; "" ] ;	// Form Feed
		[ Char ( 14 ) ; "" ] ;	// Shift Out
		[ Char ( 15 ) ; "" ] ;	// Shift In
		[ Char ( 65279 ) ; "" ]	// BOM
	) ;
_RESULT =
	TextFormatRemove ( _EDITED )

] ;

_RESULT

)

RemoveControlCode ( Text )
2020.01.07, Koji Takeuchi

description:
Remove control codes (ex. VT as in-cell return code of Excel).
And also remove every formatting like bold, italic, etc.

Comments

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

RemoveControlCode ( Text )

Comments

Support this website.

Support this website.