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 DEBIAN
jifty::dbi::filter::yaml
Jifty::DBI::Filter::YAML(3pm) User Contributed Perl Documentation Jifty::DBI::Filter::YAML(3pm)NAME
Jifty::DBI::Filter::YAML - This filter stores arbitrary Perl via YAML
SYNOPSIS
use Jifty::DBI::Record schema {
column my_data =>
type is 'text',
filters are qw/ Jifty::DBI::Filter::YAML /;
};
my $thing = __PACKAGE__->new;
$thing->create( my_data => { foo => 'bar', baz => [ 1, 2, 3 ] } );
my $my_data = $thing->my_data;
while (my ($key, $value) = %$my_data) {
# do something...
}
DESCRIPTION
This filter provides the ability to store arbitrary data structures into a database column using YAML. This is very similar to the
Jifty::DBI::Filter::Storable filter except that the YAML format remains human-readable in the database. You can store virtually any Perl
data, scalar, hash, array, or object into the database using this filter.
In addition, YAML (at least the storage of scalars, hashes, and arrays) is compatible with data structures written in other languages, so
you may store or read data between applications written in different languages.
METHODS
encode
This method is used to encode the Perl data structure into YAML formatted text.
decode
This method is used to decode the YAML formatted text from the database into the Perl data structure.
IMPLEMENTATION
This class will attempt to use YAML::Syck if it is available and then fall back upon YAML. This has been done because the Syck library is
written in C and is considerably faster.
SEE ALSO
Jifty::DBI::Filter, YAML, YAML::Syck
AUTHOR
Andrew Sterling Hanenkamp <hanenkamp@cpan.org>
LICENSE
This program is free software and may be modified or distributed under the same terms as Perl itself.
perl v5.14.2 2010-09-21 Jifty::DBI::Filter::YAML(3pm)