trevoray
asked on
How can I remove hidden paragraph in data?
I am trying to clean up submitted data in my database to display in an export. There is one character that I do not know to get rid of. It creates a new line break in my text editor and I've attached screenshot of what this character looks like in text editor when I choose show hidden characters. I've already removed the following characters:
strOtherHelp = Replace(strOtherHelp, Chr(10), " ")
strOtherHelp = Replace(strOtherHelp, Chr(13), " ")
strOtherHelp = Replace(strOtherHelp, vbCrLf, " ")
Screen-Shot-2011-09-02-at-8.59.2.png
strOtherHelp = Replace(strOtherHelp, Chr(10), " ")
strOtherHelp = Replace(strOtherHelp, Chr(13), " ")
strOtherHelp = Replace(strOtherHelp, vbCrLf, " ")
Screen-Shot-2011-09-02-at-8.59.2.png
parse strOtherHelp char by char and display the character and asc(character) and you'll find out the code for the character.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.