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!
