Help

Count unique lines on a long text field

Topic Labels: Formulas
554 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jorge_Gonzalez
5 - Automation Enthusiast
5 - Automation Enthusiast

I have some entries that have a long text field for example

example.com
example2.com

example2.com

Is there a way to show the total unique urls?

I have this formula

ABS(IF(LEN(SUBSTITUTE(TRIM({URL/Video Match URL}),"\n","")) > 1, LEN(SUBSTITUTE(TRIM({URL/Video Match URL}),"\n","")) - 1 , LEN(SUBSTITUTE(TRIM({URL/Video Match URL}),"\n",""))) - LEN(TRIM({URL/Video Match URL})))

But this formula only counts the total of the lines/urls. I wish to only count the unique urls.
The name of the field is: URL/Video Match URL

0 Replies 0