Moving data based on criteria

shingrac

Hello! I am attempting to move data from one field to another. In my data, I have a PO box field, but that field contains addresses and other data that does not belong. How can I set up the formula to filter that information out and place into the correct field?

As you can see in the photo, the "18 Main Street" would be data that would go into the "Address" field. The "University of Southern California" is data that would go into the "Vendor Notes" field. Is there a formula that will do all those actions in one? 

See the fields above.

Thank you in advance for your help!

AngelosPachis

Hi @shingrac ,

I have created a workflow that answers your question, but I am unsure if this will be able to address the issue across the whole dataset.

We should know more about the pattern of strings that appear in that PO Box field, to better refine the solution to match your case.

However, give this a try and let me know if you have any question on what it does. In principal, you should be able to adopt the logic in your workflow and answer your question with some tweeks.

Hope that helps

Angelos

example.yxmd