How to identify bullets with a formula?

1

Is it possible to identify a bullet in a text or canvas column? Like use regex/regular expressions or another hack? I’ve tried using Charactor() function as well as _merge without success.

What about identifying a sub-bullet / indented bullet?

2

HI Ryan,

I have not tried it myself, but hopefully find() will work:

3

Tried find but no hits. Here’s my test doc

It’s possible all string based searches convert the value to text and stip the bullets out before comparison so using Character() function or the actual • symbol won’t work.

Is this possible using formulas?

4

hi @Ryan_Hubbard ,

maybe this blog helps you to get what you have in mind:

cheers, Christiaan

3 Likes
5

Thanks @Christiaan_Huizer . Grabbing the JSON from the column does the trick!

2 Likes
6

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