Sponsored Content
Top Forums Shell Programming and Scripting To fetch specific words from a file Post 302350202 by girish.raos on Thursday 3rd of September 2009 04:59:56 AM
Old 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

Search File for Specific Words

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

Reading a file for specific words

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

How to fetch a specific line from file

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

fetch last line no form file which is match with specific pattern by grep command

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

Match the word or words and fetch the entries

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

Match words and fetch data in front of it in second column

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

Urgent request to consider:Search specific name in a file and fetch specific entries

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

Search specific name in a file and fetch specific entries

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

How to replace some specific words from file?

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

How to fetch specific data from a file.?

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)
All times are GMT -4. The time now is 07:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy