How to Remove Characters but Keep Decimal Point in MS Access Field?

jchunglo

New member
Local time
Today, 18:42
Joined
Apr 5, 2019
Messages
2
I currently have a very large data set and I would like to remove all of the characters in the results field but keep the numbers and decimal point. What is the best way to do this?

Here is an example of what the result field looks like:
52.4,*,H
102.9,*^,H
34.5,*,H
30.9
>150.0,*^@,H
82.1,*,H

I would like the output to be:
52.4
102.9
34.5
30.9
150.0
82.1
 
I use a public function that loops through the value. It uses Asc() to test the value of each digit, and only returns the desired ones.
 

Users who are viewing this thread

Back
Top Bottom