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
Oct 28, 2019 07:01 AM
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
Oct 28, 2019 04:09 PM
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 “.”