Pattern for specific regex VBA excel

Question

I have a string like this : "+33 (0)1 75 32 33 34", i want this result : +331 75 32 33 34 And I fail to find the pattern to use to have this result

Have you any idea ?

vks · Accepted Answer · 2014-12-05 14:48:53Z

2

Find \s*$[^)]+$

Replace by empty string.

answered Dec 5, 2014 at 14:48

vks

68.1k11 gold badges96 silver badges132 bronze badges

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

5 Comments

Jerome Campeaux Over a year ago

I want to remove parantheses and value inside only if the value is 0, if the value in the parantheses is for example 1 I just want to remove parantheses but not the value. Do you know if it is possible or not ?

vks Over a year ago

@JeromeCampeaux \s*$0$|\s*$[^0)]+$

Jerome Campeaux Over a year ago

@ vks I tried to undestand your regex but i don't understand it. And I still have an issue + (33) (0) 1 55 24 72 67 become + 1 55 24 72 67 and I want +331 55 24 72 67. Sorry for the inconvenience.

vks Over a year ago

\s*$0$|\s*$([1-9])$ try this @JeromeCampeaux replace by $1.

Jerome Campeaux Over a year ago

I have this + (33) 1 55 24 72 67

Collectives™ on Stack Overflow

Pattern for specific regex VBA excel

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related