?
Solved

How can I remove hidden paragraph in data?

Posted on 2011-09-02
2
Medium Priority
?
257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Expert Comment

by:madgino
ID: 36473640
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 2000 total points
ID: 36473842
try Chr(20)

Arun
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses
Course of the Month8 days, 1 hour left to enroll

765 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