Separate subdomain(.)domain(.)com to array value 1,2,3

[Alexander_V]

Hi there
I have one field with value subdomain(.)domain(.)com, domain(.)com and etc.
I need to get N fields separate source value by (.)

The result will be
for subdomain(.)domain(.)com
field 1 subdomain
field 2 domain
field 3 com

for domain(.)com
field 1 (empty)
field 2 domain
field 3 com

Thank you

[Btbml]

As long as you have some consistency its pretty simple to build a formula around this. Instead of fully explaining it, below I have linked a sample.

There are 2 fields which find each of the “.” in the url. You don’t need these to be formulas, you can build it into the other formulas but I thought for simplicity of showing this would work best. The other formulas check against the “second .” field to see if there is a second “.”. It then runs the LEFT, MID, or RIGHT formula to extract the information using the positions of the “.”

Airtable

test 2 - Airtable

Explore the "test 2" base on Airtable.