09-03-2009
To fetch specific words from a file
Hi All,
I have a file like this,(This is a sql output file)
cat query_file
200000029
12345 10001
0.2 0
I want to fetch the values 200000029,10001,0.2 .I tried using the below code but i could get only the 200000029
NOTE: The query_file contains similar kind of records.
cat query_file | awk -F " " '/[[:digit:]]/ { print $1 }'
Can anyone please help me to do this.
Thanks in advance,
Giri
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a file that contains the following:
Mon Dec 3 15:52:57 PST 2o007: FAILED TO PROCESSED FILE 200712030790881200.TXT - exit code=107
Tue Dec 4 09:08:57 PST 2007: FAILED TO PROCESSED FILE 200712030790879200a.TXT - exit code=107
This file also has a lot more stuff since it is a log file.... (2 Replies)
Discussion started by: mevasquez
2 Replies
2. UNIX and Linux Applications
Hi
I have a script where the user calls it with arguments like so:
./import.sh -s DNSNAME -d DBNAME
I want to check that the database entered is valid by going through a passwd.ds file and checking if the database exists there.
If it doesn't, the I need to send a message to my log... (4 Replies)
Discussion started by: ladyAnne
4 Replies
3. Shell Programming and Scripting
Hi,
I have text file in the following strucher .
The files contain hondreds of lines.
value1;value2;value3;value4
I would like to get back the line with lowest date (values4 field).
In this case its line number 3.
groupa;Listener;1;20110120162018
groupb;Database;0;20110201122641... (4 Replies)
Discussion started by: yoavbe
4 Replies
4. Shell Programming and Scripting
Hi
i have a file which have a pattern like this
Nov 10 session closed
Nov 10 Nov 9 08:14:27 EST5EDT 2010 on tty .
Nov 10 Oct 19 02:14:21 EST5EDT 2010 on pts/tk .
Nov 10 afrtetryytr
Nov 10 session closed
Nov 10 Nov 10 03:21:04 EST5EDT 2010
Dec 8 Nov 10 05:03:02 EST5EDT 2010
... (13 Replies)
Discussion started by: Himanshu_soni
13 Replies
5. Shell Programming and Scripting
Hi all,
I have 7 words
Now I have 1 file which contain data in large number of rows and columns
and 6th column contain any of these words or may be more than one words among above 7 words:
I want
script should search for the above mentioned 7 words in the 6th column
... (9 Replies)
Discussion started by: manigrover
9 Replies
6. Shell Programming and Scripting
Hi all,
I have 2 files
one file contain data like this in one column
AST3
GSTY4
JST3
second file containign data like this in 2 columns
AST3(PAXXX),GSTY4(PAXXY) it is used in diabetes
KST4 it is used in blood... (6 Replies)
Discussion started by: manigrover
6 Replies
7. Shell Programming and Scripting
Hi all,
I have 2 files, One file contain data like this
FHIT
CS
CHRM1
PDE3A
PDE3B
HSP90AA1
PTK2
HTR1A
ESR1
PARP1
PLA2G1B
These names are mentioned in the second file(Please see attached second file) as
# Drug_Target_X_Gene_Name:(Where X can be any number (1-1000) (1 Reply)
Discussion started by: manigrover
1 Replies
8. Shell Programming and Scripting
Hi all,
I have 2 files, One file contain data like this
FHIT
CS
CHRM1
PDE3A
PDE3B
HSP90AA1
PTK2
HTR1A
ESR1
PARP1
PLA2G1B
These names are mentioned in the second file(Please see attached second file) as (7 Replies)
Discussion started by: manigrover
7 Replies
9. Shell Programming and Scripting
I have the file like this.
cat 123.txt
<p> <table border='1' width='90%' align='center' summary='Script output'> <tr><td>text </td> </tr> </table> </p>
I want to replace some tags and want the output like below. I tried with awk & sed commands. But no luck. Could someone help me on this?
... (4 Replies)
Discussion started by: thomasraj87
4 Replies
10. UNIX for Beginners Questions & Answers
Hi ,
I have a file which contains 2 days logs(here it is 24 and 25)
I want to list data only for date 25 fron the file.
please suggest me how should i get this.
file content mentioned below
17-05-24 Name Succ Fail
00:00:29 ... (5 Replies)
Discussion started by: scriptor
5 Replies
DPMGR(1) Quick Database Manager DPMGR(1)
NAME
dpmgr - administration utility for QDBM Depot
SYNOPSIS
dpmgr create [-s] [-bnum num] name
dpmgr put [-kx|-ki] [-vx|-vi|-vf] [-keep|-cat] [-na] name key val
dpmgr out [-kx|-ki] name key
dpmgr get [-nl] [-kx|-ki] [-start num] [-max num] [-ox] [-n] name key
dpmgr list [-nl] [-k|-v] [-ox] name
dpmgr optimize [-bnum num] [-na] name
dpmgr inform [-nl] name
dpmgr remove name
dpmgr repair name
dpmgr exportdb name file
dpmgr importdb name file
dpmgr snaffle [-kx|-ki] [-ox] [-n] name key
dpmgr version
DESCRIPTION
This manual page documents briefly the dpmgr commands.
dpmgr is a utility for debugging Depot and its applications. It features editing and checking of a database. It can be used for database
applications with shell scripts. This command is used in the above format. name specifies a database name. key specifies the key of a
record. val specifies the value of a record.
OPTIONS
A summary of options is included below. For a complete description, see the file:///usr/share/doc/qdbm-doc/spex.html#depotcli.
-s make the file sparse.
-bnum num
specify the number of the elements of the bucket array.
-kx treat key as a binary expression of hexadecimal notation.
-ki treat key as an integer expression of decimal notation.
-vx treat val as a binary expression of hexadecimal notation.
-vi treat val as an integer expression of decimal notation.
-vf read the value from a file specified with val.
-keep specify the storing mode for `DP_DKEEP'.
-cat specify the storing mode for `DP_DCAT'.
-na do not set alignment.
-nl open the database without file locking.
-start specify the beginning offset of a value to fetch.
-max specify the max size of a value to fetch.
-ox treat the output as a binary expression of hexadecimal notation.
-n do not output the tailing newline.
-k output keys only.
-v output values only.
SEE ALSO
qdbm(3), dptsv(1), dpopen(3).
AUTHOR
QDBM was written by Mikio Hirabayashi <mikio@fallabs.com>.
This manual page was written by Fumitoshi UKAI <ukai@debian.or.jp>, for the Debian project (but may be used by others).
Man Page 2005-05-23 DPMGR(1)