Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following formula:



 source!A2="Ancien Marché Saint-Jacques (1125, rue Ontario Est)" 

and I would like to extract

Ancien Marché Saint-Jacques

however I'm getting an error saying

Invalid escape sequence: \À

Any other idea on how to deal with the french characters?

share|improve this question
Well, I got it to work changing my expression to: ^[\w\s\\À-ÿ-’']+ so double escaping seems to be required in this case – AlvaroFG Jul 28 '13 at 2:09
up vote 1 down vote accepted

Well, I got it to work changing my expression to:


so double escaping seems to be required in this case

share|improve this answer

The square brackets, used in your regex example, indicate that you are searching for text within brackets. Losing the first straight bracket, wouldn't yield the expected outcome.

Therefore, if this is the way all data is being presented,

Description of Object (postal code, street),

then this will be of use as well:

=INDEX(SPLIT(source, "("),1,1)

The SPLIT() function will split the result, where the first ( occurs. The INDEX() function will only show the first row (1) on the first column (1).

share|improve this answer
Hi @Jacob, great suggestion (i guess once one learn how to use a hammer (regex) everything looks like nails). Unfortunately, for me, while all the information is withing brackets, not all of them is the expected address. Example: Cathédrale Saint-Jacques-le-Majeur (aujourd'hui cathédrale Maie-Reine-du-Monde - boulevard Dorchester Ouest, aujourd'hui boulevard René-Lévesque Ouest) (here I don't expect anything in return, it is just too complex) Bibliothèque Saint-Sulpice (devenue Bibliothèque nationale du Québec- 1700, rue Saint-Denis) Here I'm getting 1700, rue Saint-Denis, which is ok – AlvaroFG Aug 7 '13 at 20:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.