Neo.ClientError.Statement.SyntaxError: Invalid input 'S': expected 'n/N' (line 1, column 69 (offset: 68))

Neo4j Graph Platform Cypher
1

Hello team ,

Need your help in correcting the query:

MATCH(n:FTTX_PATH) where split(n.PATH_NAME,'_')[2] contains 'AAR' AS EDU RETURN n.EDU

ERROR:
Neo.ClientError.Statement.SyntaxError: Invalid input 'S': expected 'n/N' (line 1, column 69 (offset: 68))
"MATCH(n:FTTX_PATH) where split(n.PATH_NAME,'_')[2] contains 'AAR' AS EDU RETURN n.EDU"

Regards
Akshat

2

It isn't expressed this way. Rather do this:

=~ '.*AAR.*'

3

Hello David,

Still getting the error:

MATCH(n:FTTX_PATH) where split(n.PATH_NAME,'_')[2] =~ '.AAR.' AS EDU RETURN n.EDU

Neo.ClientError.Statement.SyntaxError: Invalid input 'S': expected 'n/N' (line 1, column 66 (offset: 65))
"MATCH(n:FTTX_PATH) where split(n.PATH_NAME,'_')[2] =~ '.AAR.' AS EDU RETURN n.EDU"
^

I believe it is having issue with alias name ( AS ).

Best Regards
Akshat