regular expression to find a repeated code

Question

I am trying to write a reg expression to find match of strings / code in a database.

here is some of the sample code / string which i need to remove using the regular expression.

[b:1wkvatkt] 
[/b:1wkvatkt]
[b:3qo0q63v]
[/b:3qo0q63v]
[b:2r2hso9d]
[/b:2r2hso9d]

Anything that match [b:********] and [/b:********]

Anybody please help me out. Thanks in advance.

What language are you using? What have you tried? What doesn't work? — Toto
– Toto, Commented Mar 26, 2017 at 12:08
If you're trying to do this with SQL then you'll have to tell what kind of database you use. Since regex stuff isn't part of standard ANSI SQL. Anyway, a regex to match those : \[\/?b:[a-z0-9]+\] — LukStorms
– LukStorms, Commented Mar 26, 2017 at 13:02
What do i need to do if i want to replace the pattern [b:********] and [/b:********] with <b> and </b> — pradip
– pradip, Commented Mar 26, 2017 at 15:56

ssc-hrep3 · Accepted Answer · 2017-03-26 21:03:34Z

1

You can use the following pattern (as stated by LukStorms in the comments):

\[\/?b:[a-z0-9]+\]

If you want to replace [b:********] with <b> (and also the closing one), you can use the following snippet (here in JavaScript, other languages are similar):

var regex = /\[(\/)?b:[a-z0-9]+\]/g;
var testText = "There was once a guy called [b:12a345]Peter[/b:12a345]. He was very old.";

var result = testText.replace(regex, "<$1b>");
console.log(result);

It matches an optional / and puts it into the first group ($1). This group can then be used in the replacement string. If the slash is not found, it won't be added, but if it is found, it will be added to <b>.

answered Mar 26, 2017 at 21:03

ssc-hrep3

16.3k8 gold badges51 silver badges96 bronze badges

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

Collectives™ on Stack Overflow

regular expression to find a repeated code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related