RegEx match for string in vb.net

Question

I am looking for an easy way using regex to change the format of a string. this is what I have

POL-CAD-OPT-1-15-31Oct14
INS-DOT-OPT-5-7-13Jun14
BOL-GUP-OPT-5-5-28Oct14

this is what it should be

POL-CAD-OPT-01-15-31Oct14
INS-DOT-OPT-05-07-13Jun14
BOL-GUP-OPT-05-05-28Oct14

right now I am using old split feature to construct the string using if length = 1 then add 0.

is there anything I can do with RegEx ?

You could probably use the replace functionality in RegEx...would have to search to show you as I haven't done it for ages. +1 though for proper use of RegExes :) — Tim
– Tim, Commented Nov 2, 2014 at 22:36

alpha bravo · Accepted Answer · 2014-11-02 22:53:54Z

3

Edit per comment below : use this pattern
-(\d)(?=-) and replace with -0$1
Demo

-                        '-'
(                        group and capture to \1:
  \d                       digits (0-9)
)                        end of \1
(?=                      look ahead to see if there is:
  -                        '-'
)                        end of look-ahead

edited Nov 2, 2014 at 22:53

answered Nov 2, 2014 at 22:41

alpha bravo

7,9681 gold badge24 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PaulWill Over a year ago

that works but some string like this one, is having issue.. POL-CAD.OPT-4-6-29Sep14.IP

Collectives™ on Stack Overflow

RegEx match for string in vb.net

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related