I am just begginer in perl. Just want to do following task through regular expression.

I have huge sql file and trying to replace value of each line first 4 digit separated by comma.

FILE 1: 

(7, 0, 7, 55, NULL, 0, '', 'Wise Package Studio Overview and its advan
+tage', 1260350867, '203.145.176.177', 0, 0, 0, 0, 197, 0, 0, 0, ''),
(8, 0, 8, 55, NULL, 0, '', 'what is Tarma QuickInstall 2 and its usage
+', 1260351089, '203.145.176.177', 0, 0, 0, 0, 61, 0, 0, 0, ''),
(9, 0, 9, 55, NULL, 0, '', 'what is  Tarma Installer 5 and its usage?'
+, 1260351321, '203.145.176.177', 0, 0, 0, 0, 253, 0, 0, 0, ''),
(10, 0, 10, 56, NULL, 0, '', 'what is Tarma ExpertInstall 3 and its us
+age?', 1260351466, '203.145.176.177', 0, 0, 0, 0, 69, 0, 0, 0, ''),
(11, 0, 11, 55, NULL, 0, '', 'What is Smart Install Maker and its usag
+e?', 1260351588, '203.145.176.177', 0, 0, 0, 0, 241, 0, 0, 0, ''),
(14, 0, 14, 55, NULL, 0, '', 'what is MSI Studio and its use?', 126035
+2667, '203.145.176.177', 0, 0, 0, 0, 174, 0, 0, 0, ''),

[download]

FILE 2 : It should be manipulated from first file based on following specification...

First Digit - should be incremented by 1

Second Digit - if its 0, no change but with others digit +3

Third Digit -Should be added +3

Fourth Digit - if 55 then make it 65 and if 56 then make it 66

Rest digit should remain unchanged.

Any help on this? I am basically got stuck in regular expression part

In reply to Advance Regular expression questions by rajeshatbuzz

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.