Count unique lines on a long text field

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

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.