Handy PowerShell Script When Working With Text Fields

Whenever I get a requirement that involves working with a field that contains freeform text such as Single Line Text
, Multi Line Text
, or Rich Text
, one of the first things I do is consider all of the unique character values that are at play. If one is not careful with said values, it can result in myriad issues and errors.
The Script
Use this script to help you get the full picture of what you need to account for:
You will see an output such as:
&(),-/<;3ABCDEFGHIKLMNOPRSTUVWXYabcdefghijklmnopqrstuvwxyz®
Make note of characters which may be treated as special or escape characters wherever you are using them. Also make note of arrow characters (<
) which potentially indicate HTML or XML content where you may not be expecting it.
Conclusion
With this information in mind, you can be proactive and realistic about processing, sanitization, display, and design requirements. This will also help identify which values or items require extra attention during testing.
Be unique,
-MG