regexmatch.dev
Explore
Open main menu
Save & Share
Facebook
Twitter
Tumblr
E-Mail
Pinterest
LinkedIn
Reddit
nginx log parser
Published on Tue Mar 01 2022
separate nginx log into database table-style fields
Regex
Test String
14.23.114.61 - wo.haodou.com [15/Sep/2014:16:34:46 +0800] "GET /717238/ HTTP/1.1" 200 4895 "http://www.haodou.com/recipe/472378" - 0.034 6ibgu5ha3g8ev3s6vsnf672rq1 "-" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36 SE 2.X MetaSr 1.0" "0.034"
Additional matching regexes for
nginx log parser
nginx log parser
separate nginx log into database table-style fields
CSV parsing
matches the exact fields of CSV files supports: qouted fields quoted fields containing commas, doubble quoutes, and newlines empty fields empty records arbitrary white space in, and outside quoted fields
nginx - all subdomain except "api, panel and ..."
is used for nginx nameserver regex. pass all except some subdomains.
Parser
Need everything inside this as separate variable :)
ip/host:port parser (proxy lists)
simple ip:port or host:port parser capturing ip or host and port, usually used for proxy lists
sql: insert into
insert into table ( a, b, c ) values ( " insert into values (1,2,3)",1,2.3,"a,b" ); insert into table (ee,bb,cc) values (aa,234,"asj",2.3);
GHS - PF LIMIT EXTRACTOR
Extracts from a PF file the summary table from the RAH command
Parse CSV fields
Parse an input string into fields separated by comma.
Cisco FastEthernet Ports 13-24
This regex captures Cisco-style FastEthernet ports 13-24
Cisco FastEthernet Ports 1-12
This regex will grab all Cisco-style FastEthernet ports from 1 to 12