Hi Kutsu
I couldn't reply on your thread so I thought I would just add to this one. I can actually open the file, so that is not a problem. The problem is totally in my lack of understanding on how the process works and gettng a bit of information here and there. I am a visual basic programmer, so Perl is very new to me and doesn't always seem as logical.
For instance, these are the values that are at the top row of my tab delimited file (if you think of it as an Excel spreadsheet this is line one):
"Oper_Cd","Pick_Ref_Num","Part_Id","Lot Qty","Order Id",
"Order Lineitem Id","Order Lineline Id","Sublot Num",
"Comm Invoice Num","Oper In Dt","Cust Early Shp Dt",
"Cust Late Shp Dt" ,"Current Date","Business Class Cd",
"Action Expedite Flg","Required Ship Saleable",
"Required Ship Inventory Transfer","Total Required Ships"
I want to sort the data on the file by "Cust Late Shp Dt" (Bold Highlight). Then I want to eliminate all rows of data where the the date is greater than today's date (such as tomorrow or the next day). In VB this is a very easy task, but this alludes me in Perl.
I have read the document on sorting, but to me it is not clear as to what is the proper code to use to sort by one segment of a header file. If someone could please explain this in plain english (I know, I am still learning the jargon of Perl) then I would be extremely grateful.
Portree
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.