论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2015-09-08 15:02 |只看该作者 |倒序浏览

请问怎么把一个文本里包含一行"Msg xxx, Level xx, State xx:" 的找出来呢？

Msg 2812, Level 16, State 5:
Msg 234
Server 'test', Line 1:
Stored procedure 'sphsdf' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
to check whether the object exists (sp_help may
to check whether the object exists (sp_help may
Msg 28122, Level 122, State 543:

procedure, produce, whether

文库|博客

haooooaaa

大富大贵

论坛徽章:: 54

2楼 [报告]

发表于 2015-09-08 15:29 |只看该作者

powershell

Get-Content .\c.txt | where {$_ -match "^Msg \d+, Level \d+, State \d+:$"}
Msg 2812, Level 16, State 5:
Msg 28122, Level 122, State 543:

复制代码

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

jason680

富可敌国

论坛徽章:: 145

3楼 [报告]

发表于 2015-09-08 15:30 |只看该作者

回复 1# winsonjie

$ awk '/Msg [^,]+, Level [^,]+, State [^:]+:/{print $0}' FILE
Msg 2812, Level 16, State 5:
Msg 28122, Level 122, State 543:

$ perl -lane '{print if(m/Msg [^,]+, Level [^,]+, State [^:]+:/)}' FILE
Msg 2812, Level 16, State 5:
Msg 28122, Level 122, State 543: