remove

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I have recordset.
!No = Trim$(Mid$(linedata, 108, 30))
I would like to remove any occurences of '-' in recordset.
How do I do this?
 
I have recordset.
!No = Trim$(Mid$(linedata, 108, 30))
I would like to remove any occurences of '-' in recordset.
How do I do this?
Click to expand...

With

Replace([linedata], "-", "")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to get relation links to match when they dont match 4
xml serialization of List<byte> 1
Strange pimpl problem - const correctness not respected 3
unexpected split functionality - index out of bounds 2
Question on Query Comparing 2 values 2
Totally puzzled by query incorrectly summing values 3
RoundUp in a Query? 1
query a recordset 2

Back
Top