Using one field to delete text in another
Field 1 contains text entered randomly. I'm trying to parse out various elements including phone numbers and emails.
Field 2 is a calculation field that contains email addresses extracted from Field 1.
Now I want to remove the emails from Field 1.
Since Field 2 is a calculation, I first need to replace the save the results. What is the best way to do this? Create a new field and use Lookup function?
Once the emails are safely stored, how can I remove the email addresses from Field 1? Is it possible to copy contents of Field 2. Find them in Field 1 and delete - cycling through the entire database this way?