Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

2votes

Syntax error in table formula for word count

Using the information I found on here, I used

if(length(prop(“Scene”)) > 0, length(replaceAll(prop(“Scene”), "[^ ]", "")) + 1, 0)

to get a word count in one column from the text in the column named 'Scene'.

But I get a syntax error:

Syntax error in part "“Scene”)) > 0, length(replaceAll(prop(“Scene”), "[^ ]", "")) + 1, 0)" (char 16)

What's the error?

Thanks!

1 Answer

1vote

tbbo Points840

Your formula looks good and works for me. I think the error is in the quote type that is being used in the calls to prop.

If I copy paste your formula into notion, the quotes around the property name Scene are not standard ascii quotes but fancy unicode quotes. Note how they lean and are not straight up and down.

The quotes you used in the last two arguments "[^ ]", "" are the right type.

Try changing them (you likely copy/pasted them in, just delete and re-type them) or copy this version the formula:

if(length(prop("Scene")) > 0, length(replaceAll(prop("Scene"), "[^ ]", "")) + 1, 0)

1vote

SusanM commented

YES! such a silly mistake, and I never would have found it without your help! Thank you so much!

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect