in reply to Re^11: How do I use grep in a script
in thread How do I use grep in a script

The test data posted by poj returns the expected results, so what can be the difference?

Replies are listed 'Best First'.
Re^13: How do I use grep in a script
by Flintlock (Novice) on Dec 28, 2017 at 15:49 UTC
    I have determined what the issue is attempting to add the "Name:" search.

    The Name: is actually on a separate line in the text file ie.

    STATUS Acct:142424 Disposition:9000 CANCEL Wait: 04/11/17 

DEBTOR Name:LastName FirstName Ssn:123456789 Cbr: Ph:555.555.1212

    [download]

    So I need to somehow grab both the LastName and the 142424 and concatenate then into LastName_142424_2017.txt

    while (<$fh>){
  next unless /\S/; # skip blank lines
  if (/Acct:(\d+)/){
    $acct = $1;
    if (/Name:([^\s]+)/){
      $acct = $1.'_'.$acct;
    }
  }
  push @{$data{$acct}},$_ if ($acct);
}

    [download]
    But this does not take into account for the Name: search to be on another line and still keep ALL the text to be added to the new file.

    Any suggestions on how I can accomplish this?

[reply]
[d/l]
[select]

      Are the account numbers unique such that you can build a mapping of account number => name ? 

      my %name = ();
.
.
while (<$fh>){
  next unless /\S/; # skip blank lines
  if (/Acct:(\d+)/){
    $acct = $1;
  }
  if (/Name:([^\s]+)/){
    $name{$acct} = $1;
  }
  push @{$data{$acct}},$_ if ($acct);
}

      [download]
      my $outfile = join '_',$name{$acct},$acct,'2017.txt';

      [download]
      poj
[reply]
[d/l]
[select]
        Yes Sir,

        The Acct number is unique, however, the Name: tag is NOT. It does occur elsewhere within the block of text for that acct number.

[reply]

In Section Seekers of Perl Wisdom