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
Filter file contains:
Filter.txt
ouput file should be:
Out.txt
Appreciate your help guys.
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT ULTRIX
lj250of
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)