Auto remove special character

Question

0.00/5 (No votes)

See more:

Hi, I need to auto remove special character that will be displayed in the textbox. the data from the database is like this -->1234-567-89

but i need to display it in the interface like this -->123456789.

Can anyone teach me what to add in my code so i can auto remove the special character when the data are displayed..

Posted 5-Sep-13 19:29pm

Mare7

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TheUltimateDebugger · Accepted Answer · 2013-09-05T19:31:00

Solution 1

Have a look at this link

how-remove-all-special-characters-string.html[^]

Posted 5-Sep-13 19:31pm

TheUltimateDebugger

pdoxtader · Accepted Answer · 2013-09-06T02:42:00

Solution 2

How about this:

VB

Me.TextBox1.Text = Me.TextBox1.Text.Replace("-", "")

- Pete

Posted 6-Sep-13 2:42am

pdoxtader

Comments

David Knechtges 6-Sep-13 9:08am

That won't work - he has 2 dashes at the beginning of the string.

pdoxtader 6-Sep-13 9:22am

Actually, my answer is just plain correct. It doesn't matter how many dashes there are, or what order they are in, or if they are adjacent. They will be removed.

I just tested it to confirm this, by the way, before I responded to you to make sure I was right.

- Pete

Oh - and the two dashes? That's part of an arrow he was drawing for us, pointing to his example text - not the example of his string.

David Knechtges 6-Sep-13 9:26am

Yes it is right IF the data coming back from the database does not include the "-->" at the beginning of the string. Maybe it is his question that is unclear to me. I thought his database was sending back "-->1234-567-89" and he wanted "-->123456789", which in the solution I posted below is correct.

pdoxtader 6-Sep-13 9:32am

Ok, so if the arrow is part of the string returned from the database, then he will be left with a ">" after using my solution. But my solution is just an example of how to remove specific characters from a string... I would hope he'd realize he can just use it again to remove the ">" that's left behind in that case, ie:

Me.TextBox1.Text = Me.TextBox1.Text.Replace(">", "")

- Pete

**Manoj K Bhoir** · Accepted Answer · 2013-09-08T05:55:00

Use System.Text.RegularExpressions

See the following code Example :

VB.NET

Imports System.Text.RegularExpressions

Private Function ConvertToCharNumber(ByVal Value As String) As String
        Try
            Value = Regex.Replace(Value, "[^\w]", "")
            Return Value
        Catch ex As Exception
            Return Value
        End Try
End Function

How to Use:

VB.NET

Messagebox.Show(ConvertToCharNumber("abcd-@#$1234")) 'Will Return abcd1234

I hope it will help you. :)

David Knechtges · Accepted Answer · 2013-09-06T03:10:00

Solution 3

Pete's answer is almost correct, but he doesn't account for your 2 dashes at the beginning of the string.

Try this instead:

Me.TextBox1.Text = Me.TextBox1.Substring(3).Replace("-", "")

David