Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Filter records in a huge text file from a filter text file Post 302919665 by tech_frk on Friday 3rd of October 2014 01:03:18 AM
Old 10-03-2014
Filter records in a huge text file from a filter text file

Hi Folks,

I have a text file with lots of rows with duplicates in the first column, i want to filter out records based on filter columns in a different filter text file.
bash scripting is what i need.

Data.txt
Code:
Name OrderID Quantity
Sam 123 300
Jay 342 498
Kev 78 2500
Sam 420 50
Vic 10 50
Jay 67 200
Kev 54 400
Jay 45 1000
Jay 90 500
Eli 67 90
Kev 99 430
.......................

Filter file contains:
Filter.txt
Code:
Name
Jay
Vic

ouput file should be:
Out.txt
Code:
Name	OrderID	Quantity
Vic	10	50
Jay	342	498
Jay	67	200
Jay	45	1000
Jay	90	500

Appreciate your help guys.

Last edited by tech_frk; 10-03-2014 at 02:08 AM..
 

10 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Filter data from text file

Hi All We have got a text file, which has data dumped from 60 tables. From these 60 tables of data we need data from 4 tables only. I tried assigning line numbers to filter out data, but it is not working as intended. below is the sample file ----Table1----- 3,dfs,43,df 4,sd,5,edd... (18 Replies)
Discussion started by: b_sri
18 Replies

2. Shell Programming and Scripting

filter out all the records which are having space in the 8th filed of my file

I have a file which is having fileds separtaed by delimiter. Ex: C;4498;qwa;cghy;;;;40;;222122 C;4498;sample;city;;;;34 2;;222123 C;4498;qwe;xcbv;;;;34-2;;222124 C;4498;jj;sffz;;;;41;;222120 C;4498;eert;qwq;;;;34 A;;222125 C;4498;jj;szxzzd;;;;34;;222127 out of these records I... (3 Replies)
Discussion started by: indusri
3 Replies

3. Shell Programming and Scripting

Shell script to read lines in a text file and filter user data

hi all, I have this file with some user data. example: $cat myfile.txt FName|LName|Gender|Company|Branch|Bday|Salary|Age aaaa|bbbb|male|cccc|dddd|19900814|15000|20| eeee|asdg|male|gggg|ksgu|19911216||| aara|bdbm|male|kkkk|acke|19931018||23| asad|kfjg|male|kkkc|gkgg|19921213|14000|24|... (4 Replies)
Discussion started by: srimal
4 Replies

4. Shell Programming and Scripting

Filter records in a file using AWK

I want to filter records in one of my file using AWK command (or anyother command). I am using the below code awk -F@ '$1=="0003"&&"$2==20100402" print {$0}' $INPUT > $OUTPUT I want to pass the 0003 and 20100402 values through a variable. How can I do this? Any help is much... (1 Reply)
Discussion started by: gpaulose
1 Replies

5. Shell Programming and Scripting

Filter a .kml file (xml) with data set from text file

I have a .kml file. So I want filter the .kml to get only the tags that have this numeric codes that they are in a text file 11951 11952 74014 11964 11965 11969 11970 11971 11972 60149 74018 74023 86378 11976 11980 11983 11984 11987 (5 Replies)
Discussion started by: pcoj33
5 Replies

6. UNIX for Dummies Questions & Answers

Solaris - Filter columns in text file and adding new column

Hello, I am very now to this, hope you can help, I am looking into editing a file in Solaris, with dinamic collums (lenght varies) and I need 2 things to be made, the fist is to filter the first column and third column from the file bellow file.txt, and create a new file with the 2 filtered... (8 Replies)
Discussion started by: jpbastos
8 Replies

7. Shell Programming and Scripting

Filter records based on 2nd file

Hello, I want to filter records of a file if they fall in range associated with a second file. First the chr number (2nd col of 1st file and 1st col of 2nd file) needs to be matched. Then if the 3rd col of the first file falls within any of the ranges specified by the 2nd and 3rd cols , then... (4 Replies)
Discussion started by: ritakadm
4 Replies

8. Shell Programming and Scripting

Filter all the lines with minimum specified length of words of a text file

Hi Can someone tell me which script will work best (in terms of speed and simplicity to write and run) for a large text file to filter all the lines with a minimum specified length of words ? A sample script with be definitely of great help !!! Thanks in advance. :) (4 Replies)
Discussion started by: my_Perl
4 Replies

9. Shell Programming and Scripting

Shell script to filter records in a zip file that contains matching columns from another file

Not sure if this is the correct forum for this question. I have two files. file1.zip, file2 Input: file1.zip col1, col2 , col3 a , b , 0:0:0:0:0:c436:9346:d40b x, y, 0:0:0:0:0:880:39f9:c9a7 m, n , 0:0:0:0:0:80c7:9161:fe00 file2.txt col1 c4:36:93:46:d4:0b... (1 Reply)
Discussion started by: anil.v
1 Replies

10. UNIX for Beginners Questions & Answers

Filter records from a log file based on timestamp

Dear Experts, I have a log file that contains a timestamp, I would like to filter record from that file based on timestamp. For example refer below file - cat sample.txt Jan 19 20:51:48 mukul-Vostro-14-3468 systemd: pam_unix(systemd-user:session): session opened for user root by (uid=0)... (6 Replies)
Discussion started by: mukulverma2408
6 Replies
lj250of(8)						      System Manager's Manual							lj250of(8)

Name
       lj250of - LJ250 Companion Color Printer Filter

Syntax
       /usr/lib/lpdfilters/lj250of [-c] [-nlogin] [-hhost] [-wwidth] [-lnum] [-iindent]  [accounting file]

Description
       The  filter  is used to filter text data destined for the LJ250 Companion Color printer.  The filter handles the device dependencies of the
       printers and performs accounting functions.  Accounting records are written to the file specified by the af field in at the time of comple-
       tion for each job.

       The filter can handle plain ASCII files, nroff files, and sixel files. If the printer is in HP HCL mode, the filter should be invoked using
       the lpr -x option.  The filter translates nroff control sequences for underlining, superscripting, and subscripting into the correct  LJ250
       control sequences.

       The  filter  can  be  the specified filter in both the of and the if fields in the file.  For further information, see When both fields are
       specified the of filter is used only to print the banner page.  It is then stopped to allow the if filter access to  the  printer.  The	if
       filter maintains accounting information.

       If the of field is the only one specified, the filter is used to print the banner page.	It is then stopped and restarted.  This allows the
       of filter to be used to maintain accounting information.

       If the if field is the only one specified, the banner page is sent directly to the printer. If the printer has been left in an undetermined
       state the banner page may not print correctly.

       The  best  results  are obtained when the filter is specified in both the of and if fields.  For a more detailed discussion on filters, see
       the ``Line Printer Spooler Manual'' in the ULTRIX Supplementary Documents, Volume 2: Programmer.

Options
       The filter ignores the arguments passed to it by the line printer daemon, lpd(8).  The of filter is called with the following arguments:

       lj250of -wwidth -llength
	      The width and length values come from the pw and pl fields in the database.

       The if (or restarted of) filter is passed the following arguments:

       lj250of -c -nlogin -hhost -wwidth -lnum -iindent  accounting file

Diagnostics
       The lf field (default /dev/null) in the database specifies error logging file name.

Files
       Printer capabilities database

       See Also
	      lpr(1), pr(1), printcap(5), lpd(8), MAKEDEV(8), pac(8)
	      ``Line Printer Spooler Manual,'' ULTRIX Supplementary Documents, Volume 2: Programmer

																	lj250of(8)
All times are GMT -4. The time now is 09:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy