Regex based String modification

Question

I need to modify a string using REGEX in js that too in two ways

1) Operators(AND|OR) in string must have a leading and trailing whitespace ie if say string is

(C1 AND C2 ORC3) AND (C4OR C5) then must be modified to (C1 AND C2 OR C3) AND (C4 OR C5)

2) parenthesis must not have whitespace in between them and also with conditions(Cn) ie

( ( C1 AND C2 OR C3) ) AND ( C4 OR C5) then it must be modified to ((C1 AND C2 OR C3)) AND (C4 OR C5)

operators used are only AND|OR .. nd nothing else also parenthesis are also to be only () .. no square brackets or anythin else will be there in string — Garry
– Garry, Commented Apr 10, 2013 at 6:03
Is there a problem if AND/OR are separated by two spaces rather than just one? — Explosion Pills
– Explosion Pills, Commented Apr 10, 2013 at 6:09
i need a simple regex to staisfy the condition .. @RohitJain is ques not clear enough .. — Garry
– Garry, Commented Apr 10, 2013 at 6:09
@ExplosionPills if that is the case i can trim down the multiple whitespaces with single whitespace later on.. ;) — Garry
– Garry, Commented Apr 10, 2013 at 6:10

Denys Séguret · Accepted Answer · 2013-04-10 06:08:59Z

3

You can do this :

var str = .replace(/(AND|OR)(\w)/g, "$1 $2")
          .replace(/(\w)(AND|OR)/g, "$1 $2")
          .replace(/\(\s/g, "(")
          .replace(/\s\)/g, ")");

It changes

"( ( C1 AND C2 ORC3 ) ) AND ( C4 ORC5)"

to

"((C1 AND C2 OR C3)) AND (C4 OR C5)"

It could be made shorter but would lose readability.

answered Apr 10, 2013 at 6:08

Denys Séguret

384k90 gold badges813 silver badges780 bronze badges

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

Comments

score 2 · Accepted Answer · 2013-04-10 07:49:51Z

2

I wont write a single code. But the idea will give you the solution with a little php knowledge.

replace all AND and OR with <space>AND<space> and <space>OR<space> Look carefully the second version have white spaces around them.
replace all double white space with single one. Loop through this rule untill there is no double white space.
replace (<space> with ( and <space>) with ). Again looks carefully

<space> means white space here.

edited Apr 10, 2013 at 7:49

answered Apr 10, 2013 at 6:21

user2193789

Comments

Explosion Pills · Accepted Answer · 2013-04-10 06:15:17Z

1

.replace(/\s*([()])\s*/g, "$1")
.replace(/AND|OR/g, " $& ")
.replace(/\s+/g, ' ');

This works properly on your last test string. It should account for more than one space separating parentheses and even trims extra space.

answered Apr 10, 2013 at 6:15

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

Comments

user2264587 · Accepted Answer · 2013-04-10 06:43:33Z

0

function attempt(str){
   return str.replace(/\s/g,"").replace(/(AND|OR)/g," $1 ");
}
function test(){
    var str = '( ( C1ANDC2 OR C3)          ) AND     ( C4  ORC5)',
        expected = '((C1 AND C2 OR C3)) AND (C4 OR C5)';
    return attempt(str) ===  expected;
}

answered Apr 10, 2013 at 6:43

user2264587

4742 silver badges6 bronze badges

Collectives™ on Stack Overflow

Regex based String modification

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related