Clean Data in a Feild

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get data in that I have work with that comes in a string in a single field
called Field1 that looks like like this:

203948sdf, 4,3,3, ysdifwier werioweir ** sdlfkwier jsdfj, fjdj

How can I remove all of the characters, the commas the asterisks all of it,
and also make sure there is just one space between each item so when I'm done
it would look like:

203948sdf 4 3 3 ysdifwier werioweir sdlfkwier jsdfj fjdj
 
Dear Julia:

Write a custom VBA function to do this one. In my estimate, there's going
to be a lot of extra effort in building all this functionality into a query.

Tom Ellison
 
Back
Top