Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extracting data based on the list file
Top Forums Shell Programming and Scripting Extracting data based on the list file Post 302445784 by shtobias on Tuesday 17th of August 2010 12:58:52 AM
Old 08-17-2010
Extracting data based on the list file
Hi there,

Can you help. I need to extract data based on the list file(list.txt) from item.txt as shown below. Please note the actual files are enormous in size. Thank you.

item.txt
Code:
nokia1100    123,000
nokia2100    66,000
samsung123    11,000
samsung456    23,000
iphone432    234,000
iphone678    123
cherry679    11,000
cherry123    67,456
nokia660    345,222
nokia_series    123,321
nokia4200    23,645
samsung_series    23,978

list.txt
Code:
nokia1100
iphone678
nokia4200
cherry123

output
Code:
nokia1100    123,000
iphone678    123
nokia4200    23,645
cherry123    67,456

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extracting data from text file based on configuration set in config file

Hi , a:) i have configuration file with pattren <Range start no>,<Range end no>,<type of records to be extracted from the data file>,<name of the file to store output> eg: myfile.confg 9899000000,9899999999,DATA,b.dat 9899000000,9899999999,SMS,a.dat b:) Stucture of my data file is... (3 Replies)
Discussion started by: suparnbector
3 Replies

2. Shell Programming and Scripting

Extracting lines in file based on time

Hi, anyone has any ideas on how do we extract lines from a file with format similiar to this: (based on current time) Jun 18 00:16:50 .......... ............. ............ Jun 18 00:17:59 .......... ............. ............ Jun 18 01:17:20 .......... ............. ............ Jun 18... (5 Replies)
Discussion started by: faelric
5 Replies

3. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

4. Shell Programming and Scripting

Extracting data between tags based on search string from unix file

Input file is on Linux box and the input file has data in just one line with 1699741696 characters. Sample Input: <xxx><document coll="uspatfull" version="0"><CMSdoc>xxxantivirus</CMSdoc><tag1>1</tag1></document><document coll="uspatfull"... (5 Replies)
Discussion started by: gaya
5 Replies

5. Shell Programming and Scripting

Extracting specific lines of data from a file and related lines of data based on a grep value range?

Hi, I have one file, say file 1, that has data like below where 19900107 is the date, 19900107 12 144 129 0.7380047 19900108 12 168 129 0.3149017 19900109 12 192 129 3.2766666E-02 ... (3 Replies)
Discussion started by: Wynner
3 Replies

6. Shell Programming and Scripting

extracting lines based on condition and copy to another file

hi i have an input file that contains some thing like this aaa acc aa abc1 1232 aaa abc2.... poo awq aa abc1 aaa aaa abc2 bbb bcc bb abc1 3214 bbb abc3.... bab bbc bz abc1 3214 bbb abc3.... vvv ssa as abc1 o09 aaa abc4.... azx aaq aa abc1 900 aqq abc19.... aaa aa aaaa abc1 899 aa... (8 Replies)
Discussion started by: anurupa777
8 Replies

7. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

8. Shell Programming and Scripting

Script for extracting data from csv file based on column values.

Hi all, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (3 Replies)
Discussion started by: Vivekit82
3 Replies

9. UNIX for Dummies Questions & Answers

Extracting data from one file, based on another file (splitting)

Dear All, I have two files but want to extract data from one based on another... can you please help me file 1 David Tom Ellen and file 2 David|0010|testnamez|resultsz David|0004|testnamex|resultsx Tom|0010|testnamez|resultsz Tom|0004|testnamex|resultsx Ellen|0010|testnamez|resultsz... (12 Replies)
Discussion started by: A-V
12 Replies

10. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies

LEARN ABOUT DEBIAN

oakdecode

oakdecode(1)						      General Commands Manual						      oakdecode(1)

NAME

       oakdecode - Decode an OAKT printer stream into human readable form.

SYNOPSIS

       oakdecode [options] <OAKT-file

DESCRIPTION

       oakdecode decodes an OAKT printer stream into human readable form.

       An OAKT printer stream is the printer langauge used by the HP Color LaserJet 1500 and other printers.

COMMAND LINE OPTIONS

       These are the options that can appear on the command line.

       -d basename
	      Basename of .pbm file for saving decompressed planes.

       -r basename
	      Basename of .jbg file for saving raw planes

       -i     Suppress display of image records.

       -o     Print file offsets.

       -D level
	      Set Debug level [0].

EXAMPLES

       Decode an OAKT file created by foo2oak.

       $ oakdecode < testpage.oak
       0d(80) 1 OTHER
       0c(64) Wed Nov 05 16:30:50 2003        a07d3   100005  32001e
       0a(80) testpage.pdf
       14(16) (no args)
       28(16) Source=Tray1
       29(80) PaperType=0 UNK8=2,0,0,0, blanks(63)
       2a(32) Copies=1        UNK=0
       2b(32) papercode=25    xwid=4648       ywid=9000       UNK=0
       33(64)
	       u0      u1      w       h       resx    resy    nBits
	       x0      x0      2128    4300    600     600     x1
       15(16) (no args)
	    bih0     w	   h	l0     bih5   dlen  plen unk yOff P subP
       3c(64) 00010000 2176  256  256 58030020  1050  1056 000   64 3 0
		       DL = 0, D = 0, P = 1, - = 0, XY = 2176 x 256
		       L0 = 256, MX = 32, MY = 0
		       Order   = 3  ILEAVE SMID
		       Options = 88  LRLTWO TPDON TPBON
		       1 stripes, 0 layers, 1 planes
       3c(64) 00010000 2176  256  256 58030020  3668  3680 000  320 3 0
       3c(64) 00010000 2176  256  256 58030020  1463  1472 000  640 3 0
       3c(64) 00010000 2176  256  256 58030020  1975  1984 000  896 3 0
       3c(64) 00010000 2176  224  224 58030020  2744  2752 000 1152 3 0
       3c(64) 00010000 2176  256  256 58030020   988	992 000 1440 3 0
       3c(64) 00010000 2176  256  256 58030020  2892  2896 000 1696 3 0
       3c(64) 00010000 2176  256  256 58030020  3634  3648 000 1952 3 0
       3c(64) 00010000 2176  256  256 58030020  3236  3248 000 2208 3 0
       3c(64) 00010000 2176  256  256 58030020  2279  2288 000 2464 3 0
       3c(64) 00010000 2176  256  256 58030020  3746  3760 000 2720 3 0
       3c(64) 00010000 2176  200  200 58030020  2404  2416 000 2976 3 0
       3c(64) 00010000 2176  256  256 58030020  3114  3120 000 3240 3 0
       3c(64) 00010000 2176   96   96 58030020  1142  1152 000 3496 3 0
       3c(64) 00010000 2176  256  256 58030020  2094  2112 000 3752 3 0
       3c(64) 00010000 2176  256  256 58030020  1319  1328 000 4008 3 0
       3c(64) 00010000 2176   36   36 58030020   208	224 000 4264 3 0
       17(16) (no args)
       18(16) UNK=0
       0b(16) (no args)

FILES

       /usr/bin/oakdecode

SEE ALSO

       foo2oak-wrapper(1), foo2oak(1), jbg2pbm(1)

AUTHOR

       Rick Richardson <rick.richardson@comcast.net>
       http://foo2oak.rkkda.com/
All times are GMT -4. The time now is 11:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy