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

Topic Labels: Formulas
1013 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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
7 - App Architect
7 - App Architect

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