Windows & DOS: Issues & Discussions

Hi All

We have got a text file, which has data dumped from 60 tables.
From these 60 tables of data we need data from 4 tables only.

I tried assigning line numbers to filter out data, but it is not working as intended.

below is the sample file

----Table1-----
3,dfs,43,df
4,sd,5,edd
56,df,6,fgdg
---Table2---
54,fdgfg,fgdfg
65,dgdfg,yuytr
76,tyuuu,ytur
---Table3----
98,rere,78
87,gdg,87
45,hgff,98
---Table4---
sdfsd,tyut,676
ffsdf,ggfd,879
ghgf,iyuty,877

Say from the file, i need to filter out data for Table2 and Table 3 only ...

Can any suggest a solution for this ..

Thanks in Advance
Sri....

Code:

csplit -k input_file /Table/ {99}

Code:

sed -n -e "/Table2/,/^--/{/^--/!p;/Table2/p;}" -e "/Table3/,/^--/{/^--/!p;/Table3/p;}" file

Thanks a Ton .. The Seds statement is working

Hi,

OK. This is part of solutions what I need.
How I can filter out only those tables where is information like IP=172.18.0.1?

Without an example, it's hard to guess. The example you posted so far only has 12345 and asdfghjkl, which of those is supposed to be an IP address?

Maybe it would be easier if you split the single file into multiple files first. Then it's a simple matter of grep -l IP=whatever files

Thx for your answer. Here is one example.

----Table1-----
3,dfs,43,df
4,sd,5,edd
56,df,6,fgdg
IP=172.18.0.1
---Table2---
54,fdgfg,fgdfg
65,dgdfg,yuytr
76,tyuuu,ytur
IP=172.18.0.2
---Table3----
98,rere,78
87,gdg,87
45,hgff,98
IP=172.18.0.1
---Table4---
sdfsd,tyut,676
ffsdf,ggfd,879
ghgf,iyuty,877
IP=172.18.0.1
----Table5-----
3,dfs,43,df
4,sd,5,edd
56,df,6,fgdg
IP=172.18.0.2
---Table6---
54,fdgfg,fgdfg
65,dgdfg,yuytr
76,tyuuu,ytur
IP=172.18.0.5
---Table7----
98,rere,78
87,gdg,87
45,hgff,98
IP=172.18.0.10
---Table8---
sdfsd,tyut,676
ffsdf,ggfd,879
ghgf,iyuty,877
IP=172.18.0.111

In one file there is over 100 000 tables and I want to find out those tables where IP=172.18.0.1