Regular Expressions 101

Explanation

Pro

1st Alternative"repoType":(.*?)"repo":(.*?),

"repoType":the literal text "repoType": (case sensitive)

Group 1(.*?)

.*?any character (except for line terminators), repeated any number of times

"repo":the literal text "repo": (case sensitive)

Group 2(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

2nd Alternative"resType":(.*?),

"resType":the literal text "resType": (case sensitive)

Group 3(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

3rd Alternative"result":(.*?),

"result":the literal text "result": (case sensitive)

Group 4(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

4th Alternative"policy":(.*?),

"policy":the literal text "policy": (case sensitive)

Group 5(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

5th Alternative"enforcer":(.*?),

"enforcer":the literal text "enforcer": (case sensitive)

Group 6(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

6th Alternative"sess":(.*?),

"sess":the literal text "sess": (case sensitive)

Group 7(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

7th Alternative"cliType":(.*?),

"cliType":the literal text "cliType": (case sensitive)

Group 8(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

8th Alternative"reqData":(.*?),

"reqData":the literal text "reqData": (case sensitive)

Group 9(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

9th Alternative"agentHost":(.*?),

"agentHost":the literal text "agentHost": (case sensitive)

Group 10(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

10th Alternative"logType":(.*?),

"logType":the literal text "logType": (case sensitive)

Group 11(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

11th Alternative"id":(.*?),

"id":the literal text "id": (case sensitive)

Group 12(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

12th Alternative"seq_num":(.*?),

"seq_num":the literal text "seq_num": (case sensitive)

Group 13(.*?)

.*?any character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

13th Alternative"event_count":(.*?),

14th Alternative"event_dur_ms":(.*?),

15th Alternative"tags":(.*?),

16th Alternative"additional_info":

17th Alternative"{(.)(?!$)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

"repoType":(.*?)"repo":(.*?),|"resType":(.*?),|"result":(.*?),|"policy":(.*?),|"enforcer":(.*?),|"sess":(.*?),|"cliType":(.*?),|"reqData":(.*?),|"agentHost":(.*?),|"logType":(.*?),|"id":(.*?),|"seq_num":(.*?),|"event_count":(.*?),|"event_dur_ms":(.*?),|"tags":(.*?),|"additional_info":|"{(.)(?!$)

New

{"repoType":3,"repo":"DEV01_hive","reqUser":"na230292","evtTime":"2018-05-07 07:29:16.765","access":"ALTER","resource":"stg_hr_erp_hr_erpprod/hr_dm_application_groups","resType":"@table","action":"alter","result":1,"policy":695,"enforcer":"ranger-acl","sess":"ce536988-846d-47d2-a9dc-40e88c9c3e1a","cliType":"HIVESERVER2","cliIP":"149.25.76.150","reqData":"msck repair table stg_hr_erp_hr_erpprod.hr_dm_application_groups","agentHost":"rpc11743.corp.ncr.com","logType":"RangerAudit","id":"358f75d9-8423-49e1-bd3e-3cc795cccf2e-25620","seq_num":51241,"event_count":1,"event_dur_ms":0,"tags":[blah],"additional_info":"{\"remote-ip-address\":149.25.76.150, \"forwarded-ip-addresses\":[]","cluster_name":"DEV01"}

Substitution

{"repoType":3,"repo":"DEV01_hive","reqUser":"na230292","evtTime":"2018-05-07 07:29:16.765","access":"ALTER","resource":"stg_hr_erp_hr_erpprod/hr_dm_application_groups","resType":"@table","action":"alter","result":1,"policy":695,"enforcer":"ranger-acl","sess":"ce536988-846d-47d2-a9dc-40e88c9c3e1a","cliType":"HIVESERVER2","cliIP":"149.25.76.150","reqData":"msck repair table stg_hr_erp_hr_erpprod.hr_dm_application_groups","agentHost":"rpc11743.corp.ncr.com","logType":"RangerAudit","id":"358f75d9-8423-49e1-bd3e-3cc795cccf2e-25620","seq_num":51241,"event_count":1,"event_dur_ms":0,"tags":[blah],"additional_info":"{\"remote-ip-address\":149.25.76.150, \"forwarded-ip-addresses\":[]","cluster_name":"DEV01"}