Notion Answers

Question

I had used
if(length(Name) > 0, length(replaceAll(Name, “[^ ]”, “”)) + 1, 0)
provided by one of the kind folks here in 2021.

But it is not working. I am guessing this is is because Notion released Formula 2.0? Can someone please help me with the latest code for Formula 2.0?

Answer 1 · 2023-09-19T13:11:42+0000

I'm not sure about your formula but this is the 1 I used previously.

length(replaceAll(replaceAll(replaceAll(replaceAll(replaceAll(prop("Name"), ",", ""), "\W", " "), "[ \t]+$", ""), "\s{1,}", "⨎"), "\w", ""))

Notion 2.0 shouldn't break existing formula since this require REGEX.

Question