06-12-2012
First you need to define what separates the fields. Gvien your sample it appears to be either spaces or a comma or a combination of both, the field separator would need to be [ \t,]* and to print the last there fields you can use $(NF-2), $(NF-1) and $NF. To print the result on separate lines, also print newlines, or use separate print statements..[/CODE]
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello all, :)
I have a pattern file some what like this,
cd003
cd005
cd007
cd008
and input file like this,
abc cd001 cd002 zca
bca cd002 cd003 cza
cba cd003 cd004 zca
bac cd004 cd005 zac
cba cd005 cd006 acz
acb cd006 cd007 caz
cab cd007 ... (25 Replies)
Discussion started by: admax
25 Replies
2. Shell Programming and Scripting
Input file:
adc_0123
haa_1000
bcc_520
adc_0150
bcc_290
adc_0112
haa_8000
adc_0139
haa_7000
Output file:
adc_0123 adc_0123
haa_1000
bcc_520
adc_0150 adc_0150
bcc_290 (3 Replies)
Discussion started by: patrick87
3 Replies
3. Programming
Input file:
@HWI-BRUNOP1_header_1
GACCAATAAGTGATGATTGAATCGCGAGTGCTCGGCAGATTGCGATAAAC
+HWI-BRUNOP1_header_1
TNTTJTTTETceJSP__VRJea`_NfcefbWe
Desired output file:
>HWI-BRUNOP1_header_1
GACCAATAAGTGATGATTGAATCGCGAGTGCTCGGCAGATTGCGATAAAC
>HWI-BRUNOP1_header_2... (10 Replies)
Discussion started by: cpp_beginner
10 Replies
4. Shell Programming and Scripting
how to use "awk" to print any record has pattern not equal ? for example my file has 5 records & I need to get all lines which $1=10 or 20 , $2=10 or 20 and $3 greater than "130302" as it shown :
10 20 1303252348212B030
20 10 1303242348212B030
40 34 1303252348212B030
10 20 ... (14 Replies)
Discussion started by: arm
14 Replies
5. Shell Programming and Scripting
Hi,
Do anybody know how to print out only those record that column 1 is "a" , then followed by "b"?
Input file :
a comp92 2404242 2405172
b comp92 2405303 2406323
b comp92 2408786 2410278
a comp92 2410271 2410337
a comp87 1239833 1240418
b comp87... (3 Replies)
Discussion started by: patrick87
3 Replies
6. Shell Programming and Scripting
Input file:
pattern1 100 250 US
pattern2 50 3050 UK
pattern3 100 250 US
pattern1 70 1050 UK
pattern1 170 450 Mal
pattern2 40 750 UK
.
.
Desired Output file:
pattern1 100 250 US
pattern2 50 3050 UK
pattern1 170 450 Mal
pattern2... (3 Replies)
Discussion started by: cpp_beginner
3 Replies
7. Shell Programming and Scripting
I have input file as below I need to check for a pattern and if it is there in file then I need to print all the lines below BEGIN and END keyword. Could you please help me how to get this in AIX using sed or awk.
Input file:
ABC
******** BEGIN *****
My name is Amit.
I am learning unix.... (8 Replies)
Discussion started by: Amit Joshi
8 Replies
8. Shell Programming and Scripting
Take example of below file.
abc.txt
nas1:/abc/test/test1 /test
nas1:/abc/test/test1/test2 /test/abc
nas1:/abc/test/
Now i have a variable that contains "nas1:/abc/test/test1" value , so i need to search the above file for this variable and print only this line.
... (14 Replies)
Discussion started by: mohit_vardhani
14 Replies
9. Shell Programming and Scripting
Hello, can someone guide me on this?
I don't know what is the best approach, (awk script, shell script)
I am using RedHat Linux version 6.5. There is a third party application deployed on that server. This app by default generates 5 log files and each file is 20MB. These log rollover... (5 Replies)
Discussion started by: ktisbest
5 Replies
10. Shell Programming and Scripting
Hi,
I've a file with content as below
first_block_list{
a:5
b:3
c:8
}
new_store_list(
a:1000
b:200
c:3343
)
first_item_list{
a:10
b:20
c:30
}
second_item_list{ (1 Reply)
Discussion started by: ratheeshp
1 Replies
LEARN ABOUT DEBIAN
dbf_dump
DBF_DUMP(1p) User Contributed Perl Documentation DBF_DUMP(1p)
NAME
dbf_dump - Dump the record of the dbf file
FORMAT
dbf_dump [options] files
where options are
--rs output record separator (default newline)
--fs output field separator (default colon)
--fields comma separated list of fields to print (default all)
--undef string to print for NULL values (default empty)
--memofile specifies unstandard name of attached memo file
--memosep separator for dBase III dbt's (default x1ax1a)
--nomemo do not try to read the memo (dbt/fpt) file
--info print info about the file and fields
with additional --SQL parameter, outputs the SQL create table
--version print version of the XBase library
--table output in nice table format (only available when
Data::ShowTable is installed, overrides rs and fs)
SYNOPSIS
dbf_dump -fields id,msg table.dbf
dbf_dump -fs=' : ' table
dbf_dump --nomemo file.dbf
ssh user@host 'cat file.dbf.gz' | gunzip - | dbf_dump -
DESCRIPTION
Dbf_dump prints to standard output the content of dbf files listed. By default, it prints all fields, separated by colons, one record on a
line. The output record and column separators can be changed by switches on the command line. You can also ask only for some fields to be
printed.
The content of associated memo files (dbf, fpt) is printed for memo fields, unless you use the "--nomemo" option.
You can specify reading the standard input by putting dash (-) instead of file name.
AVAILABLE FROM
http://www.adelton.com/perl/DBD-XBase/
AUTHOR
(c) 1998--2011 Jan Pazdziora.
SEE ALSO
perl(1); XBase(3pm); index_dump(1p)
perl v5.12.4 2011-08-31 DBF_DUMP(1p)