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. ThanksThis 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