Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Count unique lines on a long text field

Topic Labels: Formulas
209 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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