04-25-2012
select entry from consecutive line awk
Hi folks,
I have a file with four columns that looks like the following (tab separated)
1 1 1 a
2 2 2 b
3 3 3 c
4 4 4 d
I would like to create a file with always 4 columns but where the third entry corresponds to the thirst entry of the next line and so on, to get the following
1 1 2 a
2 2 3 b
3 3 4 c
...
any hint on how to deal with that using awk ?
Many thanks,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
The awk command awk -F: '{print $1}' test1 gives the first columns of all the lines in file ,is there some command to get a particular column from particular line .
Any help is appreciated.
thanks arif (4 Replies)
Discussion started by: mab_arif16
4 Replies
2. Shell Programming and Scripting
Hello i'm writting a krn shell that will find the letter F and I would like to grab everything from F till 0:00. Is there a sed or awk command that i could use.
Thank you. File is looks like this.
11/12 xxx xxxx xxx F xxxx xxxx
some info entered here
some info entered here
xxxx... (1 Reply)
Discussion started by: wisher115
1 Replies
3. Shell Programming and Scripting
Hi all,
I am new to awk programs.I have a file like this
vjfavhjlaf<LTEXT>aabcdfffvvbbxbcddjbv</LTEXT>fAFdfdADfd
vjfavhjlaf<LTEXT>aabcdfffvvbbxbcddjbv</LTEXT>fAFdfdADfd
vjfavhjlaf<LTEXT>aabcdfffvvbbxbcddjbv</LTEXT>fAFdfdADfd
vjfavhjlaf<LTEXT>aabcdfffvvbbxbcddjbv</LTEXT>fAFdfdADfd... (3 Replies)
Discussion started by: anju
3 Replies
4. Solaris
Hi All,
I need to get last 7 days log entries from sulog. The same has to be done for the last command.
for ex: when i search for a user "abc" in sulog, i only want to check his entries for the last 1 week.
The same has to be done for last command.
Can anyone suggest some tips.
... (0 Replies)
Discussion started by: navdeepan
0 Replies
5. UNIX for Dummies Questions & Answers
the text file like below's
input:
aaaaaaaaafdsfsda
sdfsadfasdfasfds
sdfadsf
asdfadf
asdfa
adfsfsafas
sdfsfafads
asdfasdfsa
I want to print out consecutive two line
output:
aaaaaaaaafdsfsda (1 Reply)
Discussion started by: vincent_W
1 Replies
6. Shell Programming and Scripting
I am looking at using grep to locate the line in the text file and them use awk to select a word or words out of it.
I know awk needs -v to allow a variable to be used, but also needs -F to allow the break up of the sentence and allow the location of separate variables.
$line = grep "1:" File |... (8 Replies)
Discussion started by: Ironguru
8 Replies
7. Shell Programming and Scripting
File 1
aaa
ccc
fff
File 2
aaa
bbb
ddd
File 3
aaa
bbb
eee
File 4 (4 Replies)
Discussion started by: Misa-Misa
4 Replies
8. Shell Programming and Scripting
AWK Gurus,
data:
srvhcm01 AZSCI
srvhcm01 AZSDB
srvhcm01 BZSDB
srvhcm01 E2QDI31
srvhcm01 YPDCI
srvhcm01 YPDDB
srvhcm01 UV2FSCR
srvhcm01 UV2FSBI
srvhcm01 UV2FSXI
srvhcm01 UV2FSUC
srvhcm01 UV2FSEP
srvhcm01 UV2FSRE
srvhcm01 NASCI
srvhcm01 NASDB
srvhcm01 UV2FSSL
srvhcm01 UV2FSDI (7 Replies)
Discussion started by: rveri
7 Replies
9. Shell Programming and Scripting
Dear Specialists,
I have following data
1 1 2
2 2 3
3 3 6
4 3 4
5 4 9
6 5 11
7 6 7
and I would like to obtain data like below
1 1 2
2 2 3
4 3 4
7 6 7 (2 Replies)
Discussion started by: Ryan Kim
2 Replies
10. Shell Programming and Scripting
All,
I come across the below requirement and my search on the previous posts did not result into any matches.
I have one column of data from a csv file like below. And I need to add additional column based on string count in first column.
Given column, Required column, Other columns
A, 1,... (8 Replies)
Discussion started by: ks_reddy
8 Replies
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)