I am attempting to clean up the data, prepping for an import and removing special characters and accidental user keystrokes...
I found this one record, where the user pasted text from a website three times. I got an error about the field being too small, as I was attempting to convert all double quotes to 'in.' Meaning inches.
I discovered how to remove the carriage returns and line feeds, but that left me with something interesting. In the Access text box, the characters look like double question marks each in a little box. When I iterate through the string and print out the ASCII number, I get the number for a question mark. However, using Instr function, it does not recognize them as question marks. Here is what it looks like copied and pasted from the text box:
Like wing dings or something. below is a snippet.
So, I have a two part dilemma: How do I find and remove strange looking characters?
And: What is a good way to determine and remove a repeated pasting of text into a field/textbox?
I'm experimenting with taking the first 10 or 15 characters and looking for another instance, then removing everything from that point on. Haven't finalized the workflow for that yet.
Thanks for the help!
I found this one record, where the user pasted text from a website three times. I got an error about the field being too small, as I was attempting to convert all double quotes to 'in.' Meaning inches.
I discovered how to remove the carriage returns and line feeds, but that left me with something interesting. In the Access text box, the characters look like double question marks each in a little box. When I iterate through the string and print out the ASCII number, I get the number for a question mark. However, using Instr function, it does not recognize them as question marks. Here is what it looks like copied and pasted from the text box:
Like wing dings or something. below is a snippet.
So, I have a two part dilemma: How do I find and remove strange looking characters?
And: What is a good way to determine and remove a repeated pasting of text into a field/textbox?
I'm experimenting with taking the first 10 or 15 characters and looking for another instance, then removing everything from that point on. Haven't finalized the workflow for that yet.
Thanks for the help!