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
Code:
number status date1 date2 description category type service assigned_to reported_to envioment
===== ==== === ===== ============= ============= ===== ======= ========= ======== ======
12345 open 27/06/13 28/06/13 nl21a00is-centerdb001:ncdbareq:Error in loading init Oracle Services - Trouble Tk Ticket, Auto √ DBA_SERVICE chadda,Deepak kumar DBA PROD
23456 open 27/06/13 28/06/13 nl21a00is-centerdb001:ncdbareq:Error in loading Sizing Oracle Services - Trouble Tk Ticket, Auto √ DBA_SERVICE chadda,Deepak kumar DBA TEST
45678 open 27/06/13 28/06/13 nl21a00is-centerdb001:ncdbareq:Error in loading DBMS info Oracle Services - Trouble Tk Ticket, Auto √ DBA_SERVICE chadda,Deepak kumar DBA QUALITY
24578 open 28/06/13 28/06/13 nl21a00is-centerdb001:ncdbareq:Error in loading Trig/Proc/Syn Oracle Services - Trouble Tk Ticket, Auto √ DBA_SERVICE shama,Vijay Kumar DBA PROD
45890 open 28/06/13 28/06/13 nl21a00is-centerdb001:testingQA:FSFO has configuration errors Oracle Services - Trouble Tk Ticket, Auto √ DBA_SERVICE Reddy,Ajay rao DBA PROD
I want to select " number, description, assigned_to "
description field end before category field start "Oracle Service-Trouble Tk"
assigned_to field is between two pattern DBA_SERVICE and DBA e.g. chadda,Deepak kumar
desire out out
out.txt
Code:
12345 nl21a00is-centerdb001:ncdbareq:Error in loading init chadda,Deepak kumar
23456 nl21a00is-centerdb001:ncdbareq:Error in loading Sizing chadda,Deepak kumar
45678 nl21a00is-centerdb001:ncdbareq:Error in loading DBMS info chadda,Deepak kumar
24578 nl21a00is-centerdb001:ncdbareq:Error in loading Trig/Proc/Syn shama,Vijay Kumar
45890 nl21a00is-centerdb001:testingQA:CSSO has configuration errors Reddy,Ajay rao
i want to select column1 and column5 (all description column before "category" column and third last column(which is in-between to pattern DBA_SERVICE and DBA)
Last edited by Scott; 07-02-2013 at 03:18 AM..
Reason: Please use code tags
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)
Hey guys,
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
2013/08/05 06:50:38:067 MINOR SiteScope ... (9 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)
Discussion started by: infinity0880
7 Replies
LEARN ABOUT DEBIAN
igawk
IGAWK(1) Utility Commands IGAWK(1)NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
Free Software Foundation Nov 3 1999 IGAWK(1)