Focal Point
[CLOSED] UNICODE

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3997026986

March 15, 2018, 11:21 AM
MMcDonald
[CLOSED] UNICODE
Is there a way to check and see if a field contains a Unicode character?
Especially if the field contains a emoji.
Appreciate any help.
Thanks

This message has been edited. Last edited by: FP Mod Chuck,


8.0.9, Windows
excel / pdf
March 19, 2018, 12:00 PM
FP Mod Chuck
MMcDonald

Since no one has provided any suggestions, please open a case with techusupport...


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
March 19, 2018, 10:19 PM
David Briars
Assuming your data is in a relational table...

Perhaps try converting the data to an alpha, after bringing the data back, and then doing a compare?

If only non unicode characters get converted, then perhaps the only items passing the WHERE TOTAL test will be items without the unicodes?
TABLE FILE SPECIALOFFER
PRINT   DESCRIPTION
COMPUTE DESCRIPTION_A255/A255 = DESCRIPTION;
WHERE TOTAL DESCRIPTION EQ DESCRIPTION_A255; 
END  

March 21, 2018, 02:01 PM
MMcDonald
Thanks, David!
Unfortunately when I tried your suggestion it converted the EMJOI to "¦§¨©ª«¬®¯°±²³´µ¶·¸¹º»".
We are trying have the developers in SAP write abap code to scan for these issues. I was just hoping webfocus would be able to detect emjoi's.
I did open a case but they were unable to assist. Thanks


8.0.9, Windows
excel / pdf