TXT_to_UTF8 ( Text )

Converts text to UTF-8 encoding

Average rating: 3.9 (49 votes) Log in to vote

Ibrahim Bittar Torres - Show more from this author
Eikonsys, S.A. de C.V.
http://www.eikonsys.com

Sample input:

TXT_to_UTF8 ( "México" )

Sample output:

M√©xico

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

Case ( 

Abs ( Get ( SystemPlatform ) ) = 1 ; 

Substitute ( Text ; [ "†" ; "‚Ä†" ] ; [ "°" ; "¬∞" ] ; [ "¢" ; "¬¢" ] ; [ "£" ; "¬£" ] ; [ "§" ; "¬ß" ] ; [ "•" ; "‚Ä¢" ] ; [ "\¶" ; "¬∂" ] ; [ "®" ; "¬Æ" ] ; [ "©" ; "¬©" ] ; [ "™" ; "‚Ñ¢" ] ; [ "´" ; "¬¥" ] ; [ "¨" ; "¬®" ] ; [ "≠" ; "‚â†" ] ; [ "∞" ; "‚àû" ] ; [ "±" ; "¬±" ] ; [ "≤" ; "‚â§" ] ; [ "≥" ; "‚â•" ] ; [ "¥" ; "¬•" ] ; [ "∂" ; "‚àÇ" ] ; [ "∑" ; "‚àë" ] ; [ "∏" ; "‚àè" ] ; [ "∫" ; "‚à´" ] ; [ "¿" ; "¬ø" ] ; [ "¡" ; "¬°" ] ; [ "¬" ; "¬¨" ] ; [ "√" ; "‚àö" ] ; [ "≈" ; "‚âà" ] ; [ "∆" ; "‚àÜ" ] ; [ "«" ; "¬´" ] ; [ "»" ; "¬ª" ] ; [ "…" ; "‚Ä\¶" ] ; [ "–" ; "‚Äì" ] ; [ "—" ; "‚Äî" ] ; [ "\“" ; "‚Äú" ] ; [ "\”" ; "‚Äù" ] ; [ "‘" ; "‚Äò" ] ; [ "’" ; "‚Äô" ] ; [ "÷" ; "√∑" ] ; [ "◊" ; "‚óä" ] ; [ "⁄" ; "‚ÅÑ" ] ; [ "€" ; "‚Ç¨" ] ; [ "‹" ; "‚Äπ" ] ; [ "›" ; "‚Ä∫" ] ; [ "‡" ; "‚Ä°" ] ; [ "·" ; "¬∑" ] ; [ "‚" ; "‚Äö" ] ; [ "\„" ; "‚Äû" ] ; [ "‰" ; "‚Ä∞" ] ; [ "ˆ" ; "ÀÜ" ] ; [ "˜" ; "Àú" ] ; [ "¯" ; "¬Ø" ] ; [ "˘" ; "Àò" ] ; [ "˙" ; "Àô" ] ; [ "˚" ; "Àö" ] ; [ "¸" ; "¬∏" ] ; [ "˝" ; "Àù" ] ; [ "˛" ; "Àõ" ] ; [ "ˇ" ; "Àá" ] ; [ "ª" ; "¬™" ] ; [ "á" ; "√°" ] ; [ "Á" ; "√Å" ] ; [ "à" ; "√†" ] ; [ "À" ; "√Ä" ] ; [ "â" ; "√¢" ] ; [ "Â" ; "√Ç" ] ; [ "Å" ; "√Ö" ] ; [ "å" ; "√•" ] ; [ "Ä" ; "√Ñ" ] ; [ "ä" ; "√§" ] ; [ "ã" ; "√£" ] ; [ "Ã" ; "√É" ] ; [ "Æ" ; "√Ü" ] ; [ "æ" ; "√\¶" ] ; [ "Ç" ; "√á" ] ; [ "ç" ; "√ß" ] ; [ "É" ; "√â" ] ; [ "é" ; "√©" ] ; [ "è" ; "√®" ] ; [ "È" ; "√à" ] ; [ "ê" ; "√™" ] ; [ "Ê" ; "√ä" ] ; [ "ë" ; "√´" ] ; [ "Ë" ; "√ã" ] ; [ "ﬁ" ; "Ô¨Å" ] ; [ "ﬂ" ; "Ô¨Ç" ] ; [ "ƒ" ; "∆í" ] ; [ "í" ; "√≠" ] ; [ "Í" ; "√ç" ] ; [ "ì" ; "√¨" ] ; [ "Ì" ; "√å" ] ; [ "î" ; "√Æ" ] ; [ "Î" ; "√é" ] ; [ "ï" ; "√Ø" ] ; [ "Ï" ; "√è" ] ; [ "ı" ; "ƒ±" ] ; [ "Ñ" ; "√ë" ] ; [ "ñ" ; "√±" ] ; [ "º" ; "¬∫" ] ; [ "ó" ; "√≥" ] ; [ "Ó" ; "√ì" ] ; [ "ò" ; "√≤" ] ; [ "Ò" ; "√í" ] ; [ "ô" ; "√¥" ] ; [ "Ô" ; "√î" ] ; [ "Ö" ; "√ñ" ] ; [ "ö" ; "√∂" ] ; [ "õ" ; "√µ" ] ; [ "Õ" ; "√ï" ] ; [ "Œ" ; "≈í" ] ; [ "œ" ; "≈ì" ] ; [ "Ø" ; "√ò" ] ; [ "ø" ; "√∏" ] ; [ "ß" ; "√ü" ] ; [ "ú" ; "√∫" ] ; [ "Ú" ; "√ö" ] ; [ "ù" ; "√π" ] ; [ "Ù" ; "√ô" ] ; [ "û" ; "√ª" ] ; [ "Û" ; "√õ" ] ; [ "Ü" ; "√ú" ] ; [ "ü" ; "√º" ] ; [ "ÿ" ; "√ø" ] ; [ "Ÿ" ; "≈∏" ] ; [ "µ" ; "¬µ" ] ; [ "π" ; "œÄ" ] ; [ "Ω" ; "Œ©" ] ) ; 

Abs ( Get ( SystemPlatform ) ) = 2 ; 

Substitute ( Text ; [ "°" ; "Â°" ] ; [ "¢" ; "Â¢" ] ; [ "£" ; "Â£" ] ; [ "§" ; "Â§" ] ; [ "\¶" ; "Â\¶" ] ; [ "®" ; "Â®" ] ; [ "©" ; "Â©" ] ; [ "´" ; "Â´" ] ; [ "¨" ; "Â¨" ] ; [ "±" ; "Â±" ] ; [ "¥" ; "Â¥" ] ; [ "¿" ; "Â¿" ] ; [ "¡" ; "Â¡" ] ; [ "¬" ; "Â¬" ] ; [ "«" ; "Â«" ] ; [ "»" ; "Â»" ] ; [ "÷" ; "Ã·" ] ; [ "·" ; "Â·" ] ; [ "\\" ; "\\" ] ; [ "ˆ" ; " " ] ; [ "¯" ; "Â¯" ] ;[ "¸" ; "Â¸" ] ;[ "ª" ; "Âª" ] ; [ "á" ; "Ã¡" ] ; [ "Á" ; "Ã" ] ; [ "à" ; "Ã " ] ; [ "À" ; "Ã" ] ; [ "â" ; "Ã¢" ] ; [ "Â" ; "Ã" ] ; [ "Å" ; "Ã" ] ; [ "å" ; "Ã¥" ] ; [ "Ä" ; "Ã" ] ; [ "ä" ; "Ã¤" ] ; [ "ã" ; "Ã£" ] ; [ "Ã" ; "Ã" ] ; [ "Æ" ; "Ã" ] ; [ "æ" ; "Ã¦" ] ; [ "Ç" ; "Ã" ] ; [ "ç" ; "Ã§" ] ; [ "É" ; "Ã" ] ; [ "é" ; "Ã©" ] ; [ "è" ; "Ã¨" ] ; [ "È" ; "Ã" ] ; [ "ê" ; "Ãª" ] ; [ "Ê" ; "Ã" ] ; [ "ë" ; "Ã«" ] ; [ "Ë" ; "Ã" ] ; [ "í" ; "Ã" ] ; [ "Í" ; "Ã" ] ; [ "ì" ; "Ã¬" ] ; [ "Ì" ; "Ã" ] ; [ "î" ; "Ã®" ] ; [ "Î" ; "Ã" ] ; [ "ï" ; "Ã¯" ] ; [ "Ï" ; "Ã" ] ; [ "Ñ" ; "Ã" ] ; [ "ñ" ; "Ã±" ] ; [ "º" ; "Âº" ] ; [ "ó" ; "Ã³" ] ; [ "Ó" ; "Ã" ] ; [ "ò" ; "Ã²" ] ; [ "Ò" ; "Ã" ] ; [ "ô" ; "Ã´" ] ; [ "Ô" ; "Ã" ] ; [ "Ö" ; "Ã" ] ; [ "ö" ; "Ã\¶" ] ; [ "õ" ; "Ãµ" ] ; [ "Õ" ; "Ã" ] ; [ "Ø" ; "Ã" ] ; [ "ø" ; "Ã¸" ] ; [ "ß" ; "Ã" ] ; [ "ú" ; "Ãº" ] ; [ "Ú" ; "Ã" ] ; [ "ù" ; "Ã¹" ] ; [ "Ù" ; "Ã" ] ; [ "û" ; "Ã»" ] ; [ "Û" ; "Ã" ] ; [ "Ü" ; "Ã" ] ; [ "ü" ; "Ã¼" ] ; [ "ÿ" ; "Ã¿" ] ; [ "µ" ; "Âµ" ] )

) //End Case

Each Unicode character has an UTF-8 byte value, however, the representation of these values in a text field in FileMaker are different depending on the platform. This is because the Mac Roman and the Windows 1252 (wrongly known as Latin-1) character encoding tables are different.

For example, if you want to convert the â character to UTF-8 see what happens:

In UTF-8 the character â is represented by the bytes C3 A2. If you look into the Mac Roman table you'll find that C3 is √ and A2 is ¢ but in the Windows table C3 is Ã and A2 is ¢ so to represent a high ASCII character in UTF-8 you need to use both characters. √¢ for Mac and Ã¢ for Windows.

This is exactly what this CF does. It substitutes every high ASCII character with its corresponding character pair on the Mac Roman or Windows 1252 encoding table.

This is very useful to encode an XML text calculation before converting to Base64 and sending it to a web service for example.

Enjoy.

Comments

		Ibrahim Bittar, LeÃ³n, MÃ©xico Aug 11, 2014
This function has been updated so the platform is no longer needed as a parameter. I also fixed some bugs on Windows conversion.

		Jody Barney, Codence Jun 28, 2022
Added this additional substitution to the existing custom function to assist with a specific issue that arose during an import/export scripting process. [ "ï¿½"; "'" ]

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

TXT_to_UTF8 ( Text )

Comments

Support this website.

Support this website.