Some of the data entry clerks have been entering strange data in some of the text fields of the tracker module in our Death Audit forms. I think it is due to the character sets on their keyboards. As a result we have fields like:
bebe%20murorunkwere%20donatha%20gakuru
This causes the analytics module to fail and it also does not allow us to export the data correctly.
I’ve searched and replaced most of the special characters, but I can’t figure out how to search for %20, since the percent sign is used as a wildcard. Any suggestions on how to find and replace these characters with spaces?
On Fri, Jan 31, 2014 at 11:13 AM, Wilson,Randy rwilson@msh.org wrote:
Hi all,
Some of the data entry clerks have been entering strange data in some of the text fields of the tracker module in our Death Audit forms. I think it is due to the character sets on their keyboards. As a result we have fields like:
bebe%20murorunkwere%20donatha%20gakuru
This causes the analytics module to fail and it also does not allow us to export the data correctly.
I’ve searched and replaced most of the special characters, but I can’t figure out how to search for %20, since the percent sign is used as a wildcard. Any suggestions on how to find and replace these characters with spaces?