Hi Everyone, I have a saved search on Sales Order transactions. In this search, I have a customer name like "123Test", but I want to remove the numeric part ("123") and display only "Test". Additionally, I want the name to remain clickable and link to the customer record. I am currently using the following formula: REGEXP_SUBSTR({entity}, '[A-Za-z].*')

You can use

REGEXP_REPLACE({entityid}, '^[0-9]+', '')

to remove the leading numbers, but if a customer's name actually starts with a number, it's going to remove that as well. To make it clickable, you'll have to use an HTML formula field and do something like this:

'<a href="/app/common/entity/custjob.nl?id=' || {internalid} || '" target="_blank">' || REGEXP_REPLACE({entityid}, '^[0-9]+', '') || '</a>'