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

[akshat_mittal]

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

[david_allen]

akshat.mittal:

contains 'AAR'

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

=~ '.*AAR.*'

[akshat_mittal]

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