• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 115
  • Last Modified:

TRIM ; out of a text Field


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?
1 Solution
Mike EghtebasDatabase and Application DeveloperCommented:
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.


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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now