joeyward - Viewing Profile

joeyward's Profile User Rating:

Reputation: 0 Apprentice

joeyward has not set their status

In Topic: Excel clean function in vb.net

Posted 2 Dec 2011
lattimer1999, on 02 December 2011 - 12:32 PM, said:
Use the below and it will remove that too.
```
Replace(Myclean, "&nbsp;", "")
```
Works like a charm.

Thanks for the help.
In Topic: Excel clean function in vb.net

Posted 2 Dec 2011
lattimer1999, on 02 December 2011 - 12:22 PM, said:
If I'm reading your post right. See if the below will work.
```
Dim RegExStr As String = "<[^>]*>"

Dim Myclean As String = Regex.Replace([YourSting], RegExStr, "")
```
Then the Clean string will be Myclean.

Please let me if you need anymore help.
Works great except I also need to remove &nbsp.
In Topic: Excel clean function in vb.net

Posted 2 Dec 2011

I do not understand what file you are talking about? The String comes from access database that comes from Helpdesk ticket system. And need to remove any unprintable text. Just like Clean does in Excel.

joeyward has no profile comments yet. Why not say hello?