Hiya Monks! I having a small problem here and i dunno enough about regular expressions to to solve it. Ive got this file with lines similar to this inside: 

"I000001","dummy","dummy"

[download]

when i add a new record i need to add a new id number that is in sequence with the last record entered. So for instance if the last id was 'I000199', the added record would have id 'I000200'.

There is a small problem though, that there are some id numbers randomly missing, so they arent relational to the line num.

I basically need to find the last entry with an id num, remove the 'I', look at the num and increase it by 1 but still keeping it 6 digits long, and attach it to the new entry with an 'I' prefixed in front.

I am using the split function to make each line an array. I was think of maybe using the split function again on the first element, to remove the 'I' (using substr to get the first letter)? That would leave the number but im not sure how to just read the last one so i can increase it.
I guess you can tell im tryin my hardest to avoid using regular expressions! :)

I hope someone can help

Thankya & luvya all, Jenni x.

In reply to increment id num by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • 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:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.