cleaning data

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

Guest

What code can I use to delete commas, hyphen, slashes etc. from a field and leave the data clean - update the data without all the unnecessary non-alpha numeric characters?
 
Okay, let's say you have a field Cust.Name that you want to clean

UPDATE Cust
SET Cust.Name = Replace(Replace(Cust.Name, ",", ""), " ", ""


That would take care of commas and spaces in the name field. You can nest the function more times if there are more characters to be cleaned

Regards

Frank M

----- johnduran wrote: ----

How would I use that within an update query?
 
What code can I use to delete commas, hyphen, slashes etc. from a field and leave the data clean - update the data without all the unnecessary non-alpha numeric characters?
Click to expand...

Answered in modulesdaovba. Please crosspost rather than multiposting!
 
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

Delete Specific Characters From Text 1
Clean Numbers/Text 7
Best Gmail Backup Tool to use in 2025? 3
Update qry to eliminate alpha characters 9
Parsing data 6
Remove all Characters Remains only Numeric Data 5
Windows 11 Windows 11 update 5
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5

Back
Top