Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Do I use LTRIM or REGEXP_SUBSTR?
Do I use LTRIM or REGEXP_SUBSTR if I want to return "Contact Name" in the below string on a saved search result.
5565 Company Name : Contact Name
I am able to use REGEXP_SUBSTR and identify the : and remove all that is before it using REGEXP_SUBSTR({custbody_acp_trans_contact}, '(:)(\D*)') that I found on SA article but I also want to remove the : and space after it. Just to return the name.
Amanda
Tagged:
3