Find Replace Part of Field with Blanks

[HopeCQ]

I'm looking to delete part of a field. For example, I have customer numbers that begin with "SAP-" and looking to delete this prefix, leaving just the customer number that follows the prefix (SAP-123456 would be 123456). There are other customer numbers with different prefixes that should remain.

I was thinking Find Replace would be a good tool but the "Replace Found Text With Value" is not allowing me to use the blank input field (getting "bad field type" error).

Any help using this tool or another one to accomplish this would be greatly appreciated. Thanks in advance!

[atcodedog05 · Accepted solution]

Hi @HopeCQ 

Here is how you can do it. Configure find and replace tools to replace keyword with blank column.

Workflow:

Hope this helps : )

[HopeCQ]

Perfect, thank you!!! I love this community (and Alteryx). 🙂

[atcodedog05]

Happy to help : ) @HopeCQ 

Cheers and have a nice day!

[BobbyQ]

Here is an updated version of the workflow showing the varying strings I am working with and trying to match. Is there a way to do it dynamically to essentially find and replace when they are from two different data sets? Keep in mind this is 10 lines out of 65,000. Thank you