Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
665 1
Showing results for 
Search instead for 
Did you mean: 

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

1 Reply 1

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 “.”