edge99off has asked for the wisdom of the Perl Monks concerning the following question:
Hi Monks, I have started a program that creates a new file with extension CSV; after comparing two CSV files. First it checks which file is the oldest and which file is the newest by date stamp. Then it parses data columns into an array. The problem is comparing ; I'm not sure if I should use REGEX or pattern matching to go thru 20,000 lines of data in each CSV file in less than 2 minutes without causing any damage to the files. I know how to open the files and maybe assign columns into an array then create a query or foreach loop or maybe a while loop with if then else. Basically this file gets updated twice a month so in the same month I need to compare whether Part Number's status change or quantity or price or maybe part number description which I found very unlikely. I do need a quick way to accomplish this work without making this program any longer and hard to trace. Any suggestions.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Compare CSVs FILES using REGEX or pattern matching
by GrandFather (Saint) on Dec 02, 2015 at 05:19 UTC | |
|
Re: Compare CSVs FILES using REGEX or pattern matching
by kcott (Archbishop) on Dec 02, 2015 at 05:46 UTC | |
|
Re: Compare CSVs FILES using REGEX or pattern matching
by Tux (Canon) on Dec 02, 2015 at 07:45 UTC | |
|
Re: Compare CSVs FILES using REGEX or pattern matching
by Laurent_R (Canon) on Dec 02, 2015 at 10:51 UTC | |
|
Re: Compare CSVs FILES using REGEX or pattern matching
by FreeBeerReekingMonk (Deacon) on Dec 02, 2015 at 20:49 UTC |