I'm trying to remove lines of data that contain duplicate data in a specific column.
For example.
apple 12345
apple 54321
apple 14234
orange 55656
orange 88989
orange 99898
I only want to see
apple 12345
orange 55656
How would i go about doing this? (5 Replies)
How do you delete cells from a space delimited text file given row and column number? Letś say the row number is r and the column number is c. Thanks! (5 Replies)
Hello gurus,
I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4:
NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Hi, as the title states i need to find a way to search a column for values great than 1000, and if it is, then delete that row.
An example
1 7.021 6.967 116.019 4 U 6.980E+07 0.000E+00 e 0 0 0 0
2 8.292 7.908 118.063 3 U 1.440E+07 0.000E+00 e 0 821 814 ... (3 Replies)
Hi,
I want to delete rows that have 0 at column 4.
The file looks like this:
chr01 13 61 2
chr01 65 153 0
chr01 157 309 1
chr01 313 309 0
chr01 317 469 1
chr01 473 557 0
I want to delete all rows with a 0 at column 4
chr01 13 61 2
chr01 157 309 1
chr01 ... (3 Replies)
Hi,
My input file is this way
1.1 0.0 2.4 3.5
7.9 1.8 22.3 4.7 8.9
0.9 1.3 0.0 3.4 5.6
0.0 1.1 2.2 0.0 0.0
1.1 0.0 0.0 3.4 5.6
I would like to delete the entire row, if either of 2nd and 3rd columns are 0.0.
Please note that my values are all decimal values.
So, my output would... (4 Replies)
Hi, I have a long file in the format below. I want to delete the consecutive lines that contain the same value in column 1.
I have tried awk '!x++' FS="," filename
This has not worked.
14,MM709_BHP_DM,BHP,BHP_MC709_DM
19,OFFLINE,CHE,CHEV_MC773_DM
20,M33,BP,BP_MIM775_NS_DM ... (2 Replies)
Hi guys,
i have a csv file like:
USERID;COG;DESCR;FIL;OFF
user001;user;test1;001;A01
user002;user;test2;002;A02
user0003;user;test3;003;A03
user004;user;test4;004;A04
user0005;user;test5;005;A05
etc..
I need to read line for line and, if value of first column is > 7 char (in this example... (4 Replies)
Discussion started by: kamose
4 Replies
LEARN ABOUT MOJAVE
par::filter
PAR::Filter(3) User Contributed Perl Documentation PAR::Filter(3)NAME
PAR::Filter - Input filter for PAR
SYNOPSIS
$code = 'use strict; print "Hello, World!
";';
$ref = PAR::Filter->new('PodStrip', 'Bleach')->apply($code);
print $code; # pod-stripped and obfuscated code
print $$ref; # same thing
$ref = PAR::Filter->new('PodStrip', 'Bleach')->apply('file.pl');
print $$ref; # same thing, applied to file.pl
DESCRIPTION
Starting with PAR 0.76, "pp -f" takes a filter name, like "Bleach", and invokes this module to transform the programs with
PAR::Filter::Bleach. Similarily, "pp -F Bleach" applies the Bleach filter to all included modules.
It is possible to pass in multiple such filters, which are applied in turn.
The output of each such filter is expected be semantically equivalent to the input, although possibly obfuscated.
The default list of filters include:
o PAR::Filter::Bleach
The archetypical obfuscating filter.
o PAR::Filter::Obfuscate
Use B::Deobfuscate to strip away indents and comments, as well as mangling variable names.
o PAR::Filter::PatchContent
Fix PAR-incompatible modules, applied to modules by default.
o PAR::Filter::PodStrip
Strip away POD sections, applied to modules by default.
o PAR::Filter::Bytecode
Use B::Bytecode to strip away indents and comments. This filter is deprecated! For source hiding, have a look at PAR::Filter::Crypto
instead and make sure to read about its caveats.
AUTHORS
Audrey Tang <cpan@audreyt.org>
COPYRIGHT
Copyright 2003-2009 by Audrey Tang <cpan@audreyt.org>.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
See <http://www.perl.com/perl/misc/Artistic.html>
perl v5.18.2 2012-01-06 PAR::Filter(3)