Extracting a Text string from a longer string

[JOHN_UYSAL]

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!

[Jeremy_Oglesby]

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:

Airtable - Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...

[JOHN_UYSAL]

Jeremy_Oglesby:

rmula 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!