AnsweredAssumed Answered

Using one field to delete text in another

Question asked by sccardais on Apr 9, 2014
Latest reply on Apr 9, 2014 by philmodjunk

Title

Using one field to delete text in another

Post

     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?

Outcomes