The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Count unique lines on a long text field

posted Jan 25, 2022 6:05:44 PM

Topic Labels: Formulas

0 621 0

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

Count unique lines on a long text field

Getting and writing new lines in long text fields ...

Is an empty field counted as 'Unique'

Line breaks in Long text that I can't remove

Automation to update a long text field with the va...

Creating new entries from a long text field