主页 / computer / 问题 / 1705492
Accepted
Priora
Asked: 2022-02-18 06:25:38 +0800 CST

查找并删除带有某些标点符号的重复行附近

  • 772

我有一个包含数百万行的文本文件。有些行包含相同的字母数字序列，但大小写和标点符号不同。我认为这些行是重复的。我想删除任何包含句点的重复行，但保留另一行（另一行通常包含下划线或破折号等标点符号）

输入：

000
111
12_34
12.34
123-456-789
123.456.789
A.B.C
a_b_c
qwerty
qwertx
abcdefghijklm.nopqrstuvwxy.z
a-B-cdeFghiJklmNopqRStuvwxy__Z
22.2
33.3

期望的输出：

000
111
12_34
123-456-789
a_b_c
qwerty
qwertx
a-B-cdeFghiJklmNopqRStuvwxy__Z
22.2
33.3
awk command-line

2 个回答

  1. Best Answer

    假设重复值是连续的！

    完成这项工作的 perl 脚本。

    未在大文件上测试！

    #!/usr/bin/perl
use strict;
use warnings;

my $file = 'file1'; # path to input file
# read the input file in memory
open my $F, '<', $file or die "unable to open '$file': $!";
my @list = <$F>;chomp @list;
# delete all . - _ from each line and add this new string in the array for comparison
my @res = map {my $tmp=$_; tr/._-//d; [lc$_,$tmp] } @list;
# memoize the first values
my $prev_tst = $res[0][0];  # contains the string without punctuation
my $prev_orig = $res[0][1]; # contains original string
# loop on other values
for my $ind (1 .. @res-1) {
    my ($tst, $orig) = ($res[$ind][0], $res[$ind][1]);
    # te string without punctuation is the same as the previous
    if ($tst eq $prev_tst) {
        # if the previous original value contains dot
        if ($prev_orig =~  tr/.//) {
            # delete it
            undef $res[$ind-1];
        # if the current original value contains dot
        } elsif ($orig =~ tr/.//) {
            # delete it
            undef $res[$ind];
        }
    }
    # memorize value for next step
    $prev_tst = $tst;
    $prev_orig = $orig;
}
# write result to result file
my $result = 'result_file'; # path to result file
open my $R, '>', $result or die "unable to open '$result': $!";

for (@res) {
    next unless defined $_; # skip undifned values
    print $R $_->[1],"\n";
}
    • 1

  2. 类似的东西

    sed 's/\./-/g; s/__*/-/g' /path/to/infile | sort -u > /path/to/outfile

    应该做的伎俩

    • 0

相关问题