in reply to Re^6: issue with output of file matching
in thread issue with output of file matching

In the input_data sub replace the chomp with this regex to remove newline and any trailing spaces on the company name. 
while ( <FILE1> ) {
    #chomp $_;
    s/\s*$//;

[download]
poj

Replies are listed 'Best First'.
Re^8: issue with output of file matching
by rruser (Acolyte) on Jun 11, 2013 at 18:20 UTC

    You are a genius poj

    Thank You so much! now on to my next bump in the road

[reply]

      I found my next bump in the road, when appending the carry over file I found that if the car moves again in the same month and has a date in file1 and not file2 it messes with the date matching: 

      I get this:
ACFX 28523 L 5/30/13 5/10/13 HALLIBURT-C        
ACFX 28523 L 5/1/13          HALLIBURT-C
should look like this:
ACFX 28523 L 5/30/13         HALLIBURT        
ACFX 28523 L 5/1/13 5/10/13  HALLIBURT-C

      [download]

      I wrote a quick script that compares the date and outputs the car numbers and I can manually fix but would like to avoid having to touch the file (more room for user error) The duplicate car number also picks up the -C when it is not a carryover. Your genius will be much appreciated.

[reply]
[d/l]

        yes they are..thanks

[reply]

In Section Seekers of Perl Wisdom