Now I know I am a PERL "novice" !!
Thank you for the "wisdom" graff.
I have updated my code so that the original stuff I had (data extraction from SQL Server using "Win32::SqlServer") can be used by the code you kindly supplied. I think that it's a excellent base but after checking the result set I think that perhaps I did not do a good job of describing some "irregularities" in the data set.
For example, the text "A1-910-ES-002B" can be found as a parent to "A1-910-ES-002B-16" (the actual record is)
A1-910-ES-002B-16|A1-910-ES-002B (pipe symbol is the delimiter).
Unfortunately, the text "A1-910-ES-002B" is also found in the child number "A1-910-ES-002B-17", which has a parent of "A1-910-ES-002B" (full record is)
A1-910-ES-002B-17|A1-910-ES-002B
I have a sneaking suspicion that the grep command is matching not only the text in isolation but any line that has that text in it.
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.