Handling single quote in AWS Cloudwatch Logs Insights

Question

Here is some text that contains single-quotes:

Cannot read property 'email' of undefined:

When I run the below query with the above text

filter @message like /Cannot read property 'email' of undefined/ | stats count()

I am not able to get a count. However, in reality there are lots of above text in my logs.

Question is , how to escape the single quotes in the query?

Have you tried to escape them like so: /Cannot read property \'email\' of undefined/? — dmigo
– dmigo, Commented Oct 19, 2019 at 14:44
Thanks for replying. I tried, but it does not gives any count. — user8479984
– user8479984, Commented Oct 20, 2019 at 8:27
And something like "Cannot read property 'email' of undefined"? Sorry for the blind guesses, I don't have AWS console at the moment :) — dmigo
– dmigo, Commented Oct 20, 2019 at 8:49
I tried: filter @message like /"Cannot read property 'email' of undefined"/ | stats count() but didnot work. Thanks again. — user8479984
– user8479984, Commented Oct 20, 2019 at 9:08
Sorry my bad. The first suggestion did WORK. By mistakenly, I was searching in an environment where the logs were not available. Using the backslash it worked under the environment where the logs were available and eventually started to give the actual count. Thanks a lot. — user8479984
– user8479984, Commented Oct 20, 2019 at 9:59

dmigo · Accepted Answer · 2019-10-20 14:07:56Z

15

You need to escape the quotes \'.
Like this:
/Cannot read property \'email\' of undefined/

answered Oct 20, 2019 at 14:07

3,0555 gold badges47 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1