that worked for the records that have that criteria. But not all the records are messed up like that. some are normal with just the Email in the Email field and phone number in the Primary_Phone field.
that worked for the records that have that criteria. But not all the records are messed up like that. some are normal with just the Email in the Email field and phone number in the Primary_Phone field.
Yes, it is helpful to know all the different data situations you are dealing with.
Let's just change the criteria to only run on records with the phrase "Primary Phone" in the Email field:
Code:UPDATE Table1 SET Table1.Email = Left([Email],InStr([Email]," ")-1), Table1.[Primary Phone] = Mid([Email],InStr([Email],"Primary Phone: ")+15,9) WHERE ((InStr([Email],"Primary Phone: ")>"0"));
It worked! Thanks!
You are welcome!