I want to get all the columns in this input file tab-delimited, i need to get the column send them to a variable. From there i could print them in shuffle and pick and select columns i want.
Here is the input sample
Code:
2013/08/05 06:50:38:067 MINOR SiteScope SiteScope:domain.test.com:Customer B: Oracle Database Server 11G - Basic:Database Counter: Tablespace Monitoring domain.test.com Metric 'CATTBS1/% Free' changed status from 'good' to 'warning' Metric 'CATTBS1/% Free' crossed 'CATTBS1/% Free >= 90' with value '96.88' DatabaseCounter CATTBS1/% Free domain.test.com:9354ce4d-0298-44f0-92ff-26c5ccadd4db:CATTBS1/% Free:Unknown:MINOR domain.test.com:9354ce4d-0298-44f0-92ff-26c5ccadd4db:CATTBS1/% Free CiHint:@@domain.test.com Unknown:Unknown:96.88 SiteScope@@domain.test.comSiteScope:domain.test.com:CATTBS1/% Free http://domain.test.com:8080/SiteScope/servlet/Main?activeid=200707457&activerighttop=dashboard&view=new&dashboard_view=Details&dashboard_model=true&sis_silent_login_type=encrypted&login=%28sisp%29knjxbqDESkAn5mKcvgTmj%2FyFwHH5Ke3m%0D%0A&password=%28sisp%29EzqXbIXEFD%2BJbE1N1T%2FZlELjja0DKaN7%0D%0A SiteScopeMonitor:OracleDatabaseServer11GBasic.1:200707457 1
2013/08/05 06:50:38:067 MINOR SiteScope SiteScope:domain.test.com:Customer B: Oracle Database Server 11G - Basic:Database Counter: Tablespace Monitoring domain.test.com Metric 'CATTBS/% Free' changed status from 'good' to 'warning' Metric 'CATTBS/% Free' crossed 'CATTBS/% Free >= 90' with value '96.88' DatabaseCounter CATTBS/% Free domain.test.com:9354ce4d-0298-44f0-92ff-26c5ccadd4db:CATTBS/% Free:Unknown:MINOR domain.test.com:9354ce4d-0298-44f0-92ff-26c5ccadd4db:CATTBS/% Free CiHint:@@domain.test.com Unknown:Unknown:96.88 SiteScope@@domain.test.com SiteScope:domain.test.com:CATTBS/% Free http://domain.test.com:8080/SiteScope/servlet/Main?activeid=200707457&activerighttop=dashboard&view=new&dashboard_view=Details&dashboard_model=true&sis_silent_login_type=encrypted&login=%28sisp%29knjxbqDESkAn5mKcvgTmj%2FyFwHH5Ke3m%0D%0A&password=%28sisp%29EzqXbIXEFD%2BJbE1N1T%2FZlELjja0DKaN7%0D%0A SiteScopeMonitor:OracleDatabaseServer11GBasic.1:200707457 1
2013/08/05 06:50:38:067 CRITICAL SiteScope SiteScope:domain.test.com:Customer B: Oracle Database Server 11G - Basic:Database Counter: Tablespace Monitoring domain.test.com Metric 'CATTBS3/% Free' changed status from 'good' to 'error' Metric 'CATTBS3/% Free' crossed 'CATTBS3/% Free >= 98' with value '99.61' DatabaseCounter CATTBS3/% Free domain.test.com:9354ce4d-0298-44f0-92ff-26c5ccadd4db:CATTBS3/% Free:Unknown:CRITICAL domain.test.com:9354ce4d-0298-44f0-92ff-26c5ccadd4db:CATTBS3/% Free CiHint:@@domain.test.com Unknown:Unknown:99.61 SiteScope@@domain.test.com SiteScope:domain.test.com:CATTBS3/% Free http://domain.test.com:8080/SiteScope/servlet/Main?activeid=200707457&activerighttop=dashboard&view=new&dashboard_view=Details&dashboard_model=true&sis_silent_login_type=encrypted&login=%28sisp%29knjxbqDESkAn5mKcvgTmj%2FyFwHH5Ke3m%0D%0A&password=%28sisp%29EzqXbIXEFD%2BJbE1N1T%2FZlELjja0DKaN7%0D%0A SiteScopeMonitor:OracleDatabaseServer11GBasic.1:200707457 1
2013/08/05 06:50:38:067 MINOR SiteScope SiteScope:domain.test.com:Customer B: Oracle Database Server 11G - Basic:Database Counter: Tablespace Monitoring domain.test.com Metric 'UNDOTBS1/% Free' changed status from 'good' to 'warning' Metric 'UNDOTBS1/% Free' crossed 'UNDOTBS1/% Free >= 90' with value '96.78' DatabaseCounter UNDOTBS1/% Free domain.test.com:9354ce4d-0298-44f0-92ff-26c5ccadd4db:UNDOTBS1/% Free:Unknown:MINOR domain.test.com:9354ce4d-0298-44f0-92ff-26c5ccadd4db:UNDOTBS1/% Free CiHint:@@domain.test.com Unknown:Unknown:96.78 SiteScope@@domain.test.com SiteScope:domain.test.com:UNDOTBS1/% Free http://domain.test.com:8080/SiteScope/servlet/Main?activeid=200707457&activerighttop=dashboard&view=new&dashboard_view=Details&dashboard_model=true&sis_silent_login_type=encrypted&login=%28sisp%29knjxbqDESkAn5mKcvgTmj%2FyFwHH5Ke3m%0D%0A&password=%28sisp%29EzqXbIXEFD%2BJbE1N1T%2FZlELjja0DKaN7%0D%0A SiteScopeMonitor:OracleDatabaseServer11GBasic.1:200707457 1
again this is tab delimited and would output like this
Hi,
I'm new to unix and i am kind of familiar with the basic commands.
can anyone suggest some good books especially for AWK scripting and SHELL scripting
thanks,
Hari (2 Replies)
I have a text file in which the text has been divided into paragraphs (two line breaks or tab marks a new paragraph) and I want to make a script which output would delete line breaks within the paragraph and the different paragraphs would be separated by two line breaks.
So, if my input file... (14 Replies)
Hi,
I am trying to understand what is happening here, new to scripting: I have a couple of these, but if I knew what was going on in one I can figure out the rest:
awk '/rpc-100083/ { $2 = "enable -r" }
$3 ~ /.NOS99dtlogin/ { $t = $2; $2 = $3; $3 = $t }
{ print }' /var/svc/profile/upgrade... (2 Replies)
Hi
I have 2 files of large size( 10 Miilions) , i want to join 2 files based on some condition .
for this taking lot of time and 100 cpu .i want to iterate the based on some value (like 1 lakh)
I put the 2 files in the associative arrays . if the array limit reaches the 1 lach join the with... (2 Replies)
Hi Experts,
I am adding a column of numbers with awk , however not getting correct output:
# awk '{sum+=$1} END {print sum}' datafile
2.15291e+06
How can I getthe output like : 2152910
Thank you..
# awk '{sum+=$1} END {print sum}' datafile
2.15079e+06 (3 Replies)
Hi, i am newbie to this site and hope to learn but problem is s but need help urgently.
Plz pm me if you are good at this.
Help will be appreciated. (11 Replies)
Hi,
This is the first time I am working with awk and I am not familiar with any commands in it. But I managed to do most of my work just left with one more. Needing your help!
I have to extract only the matrix (written within ) from a text file. For example:
1JTJ_0006_ACGC_NPNP_A_12_15.pdb ... (17 Replies)
hi all,
I am working on awk scripting.I have created two awk files and now have a requirement of replacing the contents of first file with some contents of second file.
Please find below the two files created.File1 has 3 records and File2 has 4 records.
cat File1
111,0165,CB21031251,0165,... (3 Replies)
Hi
I am beginner of shell/AWK scripting , can you please help me in select particular column and column between two pattern from a multiple column file.
file1.txt
number status date1 date2 description category ... (7 Replies)
I am trying to write a shell script that will add a date to and awk command from the command prompt.
here is the line I am having difficulties.
zgrep -i playback $dir/$1-*-errors.out.gz |cut -d '|' -f 1,11,12,15 | awk -v start=${start} -v end=${end} -F '|' '{$1>=start && $1 <=end} {print $2... (7 Replies)