• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

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, " ")
          screenshot of hidden characterScreen-Shot-2011-09-02-at-8.59.2.png
0
trevoray
Asked:
trevoray
1 Solution
 
madginoCommented:
parse strOtherHelp char by char and display the character and asc(character) and you'll find out the code for the character.
0
 
nmarunCommented:
try Chr(20)

Arun
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now