Is there a way to extract the domain from a text field that contains the URL.
hi @JHConsulting , like below?
thisRow.[the url].totext().slice(1,sum(thisRow.[the url].Find(".com"),Length(".com")))
Hi @JHConsulting ,
However, there are some caveats to take into considerations:
- You rely on a formula that is not supported (I hope it will, eventually):
- I wasn’t able to extract only the matching group, so it’s a a bit of a double work that I don’t like… Maybe somebody can find the issue.
Anyway, you put on a variable (
Regex as a column or named formula) the regex:
I hope this helps.
Thank you. Works fine with .com
Thank you. I will try it.