TRIM ; out of a text Field

NewFocusConsult
NewFocusConsult used Ask the Experts™
on
Hello,

I am trying to take ; out of text field when extracting the data out of the database.

Unfortunately the Text field with create the value ; when a user uses the carriage return when entering in text. I want to get rid of the ; when exporting data into Excel?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database and Application Developer
Commented:
What your sample data looks like. I suppose nothing complicated except it has ; deliminator.

How do you import the data? If you create a named spec (in which you indicate ; is deliminator), it will not import (or show) ; in access.

Basically, you have incomplete question and experts have to make all kind of wild guesses.

Provide sample data, sample code, etc.

Also

Dim str1 = "ABC;DFG"

You can remove ; using the following

str1 = Replace(str1, ";","")

Now MsgBox str1  returns ABCDEF without ;

Please see ​Top 10 Ways to Ask Better Questions

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial