Solved

How can I remove hidden paragraph in data?

Posted on 2011-09-02
2
251 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
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 500 total points
ID: 36473842
try Chr(20)

Arun
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

777 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