Solved

How can I remove hidden paragraph in data?

Posted on 2011-09-02
2
249 Views
Last Modified: 2012-05-12
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
Comment
Question by:trevoray
2 Comments
 
LVL 11

Expert Comment

by:madgino
Comment Utility
parse strOtherHelp char by char and display the character and asc(character) and you'll find out the code for the character.
0
 
LVL 27

Accepted Solution

by:
nmarun earned 500 total points
Comment Utility
try Chr(20)

Arun
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video discusses moving either the default database or any database to a new volume.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now