Dataview query with special characters

[the1gofer]

Is it possible to query a field that has especial characters. Specifically ()? right now I have note(s) field, and I get an unrecognized function error. Escaping the ( with ( does’t seem to work.

I’m assumint it’s normalized somehow, but I can’t see how.

What I’m trying to do

table note(s)
from "TCPA/Calls"

Things I have tried

escape characters, and various guesses at how it’s being normalized.

[Anwen]

You can access a property with a particular spelling like this:

table row["note(s)"]
from "TCPA/Calls"

[the1gofer]

@Anwen

row["note(s)"]

does that work with “with”?

I’m trying

table note as Notes
from "TCPA/Notes"
where row["notes(s)"] == 'jc v. some company'

and get

Dataview: Error: 
-- PARSING FAILED --------------------------------------------------

  1 | table note as Notes
  2 | from "TCPA/Notes"
> 3 | where row["notes(s)"] == 'jc v. some company'
    |                        ^

Expected one of the following: 

'(', 'null', boolean, date, duration, file link, list ('[1, 2, 3]'), negated field, number, object ('{ a: 1, b: 2 }'), string, variable

[Anwen]

It’s because you need only one = like this:

table note as Notes
from "TCPA/Notes"
where row["notes(s)"] = 'jc v. some company'

[the1gofer]

hmmm… same error

[Anwen]

It’s weird because it’s working for me like this :

table note as Notes
from "TCPA/Notes"
where row["notes(s)"] = "jc v. some company"

but not like this:

table note as Notes
from "TCPA/Notes"
where row["notes(s)"] = 'jc v. some company'

[the1gofer]

double quotes … yea … thanks!