search

douglascayers / sfdc-convert-notes-to-chatter-notes

📓 Easily migrate your Notes to Enhanced Notes.
https://douglascayers.com/2017/05/08/convert-notes-to-enhanced-notes/
BSD 3-Clause "New" or "Revised" License
26 stars 11 forks source link

Warn about non ASCII characters #24

Open douglascayers opened 6 years ago

douglascayers commented 6 years ago

Per John Lee,

Initially, I looked for those characters (¢ © ® ™). In the end, had to look for all non-ASCII characters and either deleted them or converted to some other ASCII character.

This is the regex I used to find all non-ascii characters "[^\x00-\x7f]" (everything in the double quotes) when I was searching in Excel.

The characters ranged from Chinese, non-printable, emoji, bullets, to MS Word smart quote characters.

Try to inspect Note content for non ascii characters that would cause Note conversion to fail and skip it so user knows to review those records. Give option in app to skip notes that may fail or attempt to convert anyways.