Help

Extracting a Text string from a longer string

Topic Labels: Formulas
1170 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JOHN_UYSAL
4 - Data Explorer
4 - Data Explorer

Hi,

I am having a hard time display a specific text string from a longer text string since the string I want to show doesn’t have a fixed number of letters.

Example:

The main String in the field is;

Status: Paid /Store: abc-store.dfeg.com /Owner: Firstname LastName

I want to display abc-store.dfeg.com in the record.

The “Status: Paid /Store:” and “Owner” are always there but the Store name ( what I want to display) and the Firstname Lastname part changes

Any idea how to tackle this?

Thanks in advance!

2 Replies 2

Is the store name always a web URL? If so, you should be able to use the new REGEX functions in a formula field to locate and extract the URL:

Hi Jeremy, thanks for your reply. The store name comes from 2 different sources, one is an URL and the other is just a text. I will look into the REGEX formula, appreciate the answer!