UnicodeEscapeDecode ( string )

Detect and decode Unicode escape strings (i.e \u2022)

Be the first to rate this function Log in to vote

Daniel - Show more from this author
https://inexi.com

Sample input:

UnicodeEscapeDecode ( "https://example.com/John_Doe_2022_\u2013_2023_stats.pdf" )

Sample output:

https://example.com/John_Doe_2022_–_2023_stats.pdf

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

/*
	UnicodeEscapeDecode ( string )
*/
While ([
	n = 0 ;
	string = string ;
	strings = Substitute ( string ; "\u" ; "¶\u" ) ;
	c = ValueCount ( strings )
]
; n < c ;
[
	n = n + 1 ;
	s = GetValue ( strings ; n ) ;
	escape = Left ( s ; 6 ) ;
	hex = Right ( escape ; 4 ) ;
	isUE = ( Length ( escape ) = 6 and Left ( escape ; 2 ) = "\u" ) ;
	dec = If ( isUE ; 
		While ( [ c = Length ( hex ) ; n = 0 ; dec = 0 ] ; n < c ;
		[
			n = n + 1 ;
			char = Upper ( Middle ( hex ;  n ; 1 ) ) ;
			dec = If ( Position ( "0123456789ABCDEF" ; char ; 1 ; 1 ) ;
				Substitute( char ; ["A";10]; ["B";11]; ["C";12]; ["D";13]; ["E";14]; ["F";15] ) + ( dec * 16 )
				; dec )
	
		] ; dec )
	 	; "" ) ;
	string = If ( dec ; Substitute ( string ; escape ; Char ( dec ) ) ; string )
] ; 
	string
)

Credit to HexToDec custom function for the decimal conversion found inside this custom function.

Comments

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

UnicodeEscapeDecode ( string )

Comments

Support this website.

Support this website.