Question

linux中如何提取特定文本中的特定数据

如下一行数据，提取其中的时间字段、SQLID->[ispace_content_info.getSame]; 、TIME COST: 1024(ms)三个信息，用|分隔符，后输出到文本
2018-11-07 15:17:32.566 | INFO | SQL_LOG | Flag=27C5733493C34824B4C01C1925C8D7B9, Thread=121, SQLID->[ispace_content_info.getSame]; EXECUTE SQL SUCCESS->[select t.* from ISPACE_
CONTENT_INFO t where t.parentcatalogid =? and upper(t.contentname)=upper(?) and t.UPLOADTYPE=1 and t.FAKEDEL=0 and t.proxytype=0 and t.versiontype in (0,1) and ( ora_h
ash(parentcatalogid||substr(upper(contentname),1,decode(instr(contentname,'(',-1,1), 0, length(contentname), instr(contentname,'(',-1,1)-1))) = ora_hash(?||upper(?))) and upper(t.c
ontentsuffix)=upper(?) and rownum<2]; PARAMETER->[1B11Z1TQM1TX0920173255am6, 1107151727, mp3];TIME COST: 1024(ms) |com.ispace.piip.app.dao.LimitSqlExecutor.executeQuery(LimitSqlExecutor.java:255)

Answer 1

cat 文件名 | grep "关键字"
//查看1000到3000行的数据cat filename | head -n 3000 | tail -n +1000