{"id":2448,"date":"2017-12-08T10:50:44","date_gmt":"2017-12-08T10:50:44","guid":{"rendered":"http:\/\/www.scmgalaxy.com\/tutorials\/?p=2448"},"modified":"2025-02-01T23:08:06","modified_gmt":"2025-02-01T23:08:06","slug":"regular-expression-perl-question","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/regular-expression-perl-question\/","title":{"rendered":"Regular expression perl question"},"content":{"rendered":"

rajeshkumar created the topic: Regular expression perl question<\/strong><\/p>\n

I am just beginner in perl. Just want to do following task through regular expression.<\/p>\n

I have huge sql file and trying to replace value of each line first 4 digit separated by comma.<\/p>\n

FILE 1:
\n(7, 0, 7, 55, NULL, 0, ”, ‘Wise Package Studio Overview and its advantage’, 1260350867, ‘203.145.176.177’, 0, 0, 0, 0, 197, 0, 0, 0, ”),
\n(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, ”),
\n(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, ”),
\n(10, 0, 10, 56, NULL, 0, ”, ‘what is Tarma ExpertInstall 3 and its usage?’, 1260351466, ‘203.145.176.177’, 0, 0, 0, 0, 69, 0, 0, 0, ”),
\n(11, 0, 11, 55, NULL, 0, ”, ‘What is Smart Install Maker and its usage?’, 1260351588, ‘203.145.176.177’, 0, 0, 0, 0, 241, 0, 0, 0, ”),
\n(14, 0, 14, 55, NULL, 0, ”, ‘what is MSI Studio and its use?’, 1260352667, ‘203.145.176.177’, 0, 0, 0, 0, 174, 0, 0, 0, ”),<\/p>\n

FILE 2 : It should be manipulated from first file based on following specification…
\nFirst Digit – should be incremented by 1
\nSecond Digit – if its 0, no change but with others digit +3
\nThird Digit -Should be added +3
\nFourth Digit – if 55 then make it 65 and if 56 then make it 66
\nRest digit should remain unchanged.<\/p>\n

Any help on this? I am basically got stuck in regular expression part<\/p>\n

Regards,
\nRajesh Kumar
\nTwitt me @ twitter.com\/RajeshKumarIn<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

rajeshkumar created the topic: Regular expression perl question I am just beginner in perl. Just want to do following task through regular expression. I have huge sql file and trying… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[14],"tags":[175],"class_list":["post-2448","post","type-post","status-publish","format-standard","hentry","category-perl","tag-perl"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=2448"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2448\/revisions"}],"predecessor-version":[{"id":2449,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/2448\/revisions\/2449"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=2448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=2448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=2448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}