Regular Expressions 101

Community Patterns

Importing Confluence Application Logs to Amazon Athena

0

Regular Expression
PCRE (PHP <7.3)

`
^(.*?) +(.*?) +(.*?) +\[(.*?)\] +\[(.*?)\] +(.+)$
`
gm

Description

Though in Athena you would need two backslash instead of one as listed above in Regex. expression in Athena. "input.regex" = '^(.?) (.?) (.?) \[(.?)\] \[(.*?)\] (.+)$'

Submitted by Chirag Parikh - a year ago