_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › RegularExpressions

Contents

1 SQL ろ襴渚語 insert 企 谿剰鍵
2 ろる.企
3 轟 覓語企 觸願鍵
4 html 蠏碁 觸願鍵
5 一危 覓語 蟲覿 csv
6 覦一(array)
7 覃覓語
8 蠍磯蓋 襷れ広
9 谿瑚


windows7 蟆曙企.
[http] 蟠朱 企 蠏, 螻企襯伎/ろ磯 襴覦伎 襴 覲碁.

1 SQL ろ襴渚語 insert 企 谿剰鍵 #

text
insert into	 [dw].[fact].[conn_users]
insert into [Fact].conn_users
insert into Fact.conn_users
insert into fact.conn_users
insert into	 dw.fact.conn_users
insert into
fact.conn_users
insert fact.conn_users(cola, colb)
update fact.conn_users
insert dim.code(cola, colb)


/(?<=insert(\s+into\s+|\s+))((\[|)\w+(\]|)|(\[|)\w+(\]|)|)(\.|)(\[|)fact(\]|)\.(\[|)\w+(\]|)/gi

蟆 覓語 蟲覿(語企 (i)螳蟆 襾轟 螻, 旧(i)朱 )
(?<=(I|i)(N|n)(S|s)(E|e)(R|r)(T|t)(\s+(I|i)(N|n)(T|t)(O|o)\s+|\s+))((\[|)\w+(\]|)|(\[|)\w+(\]|)|)(\.|)(\[|)(F|f)(A|a)(C|c)(T|t)(\]|)\.(\[|)\w+(\]|)

蟆郁骸
[dw].[fact].[conn_users]
[Fact].conn_users
Fact.conn_users
fact.conn_users
fact.conn_users
dw.fact.conn_users
fact.conn_users

2 ろる.企 #

select * 
from dw.fact.tablex a
	inner join  Dim.tabley b
		on a.id = b.id
	inner join [fact].tablec c
		on a.id = c.id
		
select * 
from dw.etl.tablex a
	inner join  realtime.tabley b
		on a.id = b.id
	inner join dbo.tablec c
		on a.id = c.id
	inner join bill.tablec d
		on a.id = d.id

\s\w+\.dim\.\w+|dim\.\w+|\w+\.fact\.\w+|fact\.\w+\s

蟆郁骸
dw.fact.tablex
Dim.tabley
[fact].tablec
dw.etl.tablex
realtime.tabley
dbo.tablec
bill.tablec

(\w+\.|)(\[|)((F|f)(A|a)(C|c)(T|t)|(D|d)(I|i)(M|m)|(E|e)(T|t)(L|l)|(R|r)(E|e)(A|a)(L|l)(T|t)(I|i)(M|m)(E|e)|(B|b)(I|i)(L|l)(L|l)|(D|d)(B|b)(O|o))(\]|)\.\w+

蟆郁骸
dw.fact.tablex
dim.tabley
fact.tablec

3 轟 覓語企 觸願鍵 #

abc2
abc
 abc
first_abc
abc_level

(\s|)\babc\b

蟆郁骸
abc
 abc

4 html 蠏碁 觸願鍵 #

<a href="http://www.aaa.com">aaa.com</a><br><br>

<[^>]*>

5 一危 覓語 蟲覿 csv #

a,"bcd, efg",h,i

(/)(?=(?:[^"]|"[^"]*")*$)

螳 蟲覿
  • a
  • "bcd, efg"
  • h
  • i

6 覦一(array) #

expression
\[\d*(?:,\s*\d+)*\]

text
Name=伎, Skill=[1, 2,3]

蟆郁骸
[1, 2,3]


7 覃覓語 #

$()*+.?[\^{|

escape 覓語
text <- "abcd $efg hig"
pattern <- "\\$efg"
unlist(regmatches(text, regexec(pattern, text)))

> unlist(regmatches(text, regexec(pattern, text)))
[1] "$efg"

譬襭蟯(]), 危(-), 譬襭譴蟯(}) 覃 覓語 觜語. 譬襭蟯(]), 危(-) 伎れ危 豌襴讌 蟯([) れ 蟆曙一襷 覃 覓語襦 語覃, 譬襭譴蟯(}) 伎れ 豌襴讌 譴蟯({) れ 蟆曙一襷 覃覓語襦 語. 譬襭 蟯 ),},] 伎れ危 豌襴 殊 覃覓語襦 覿襯讌 .

8 蠍磯蓋 襷れ広 #

覓語伎 轟 願 讌
text <- "abcd efg hig"
pattern <- "efg"
unlist(regmatches(text, regexec(pattern, text)))

> unlist(regmatches(text, regexec(pattern, text)))
[1] "efg"

蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2021-04-15 21:02:05

蟇願 企´ 覦讌 螻給 蠍一旧 伎. (る襯企 る豺)