Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have the following formula:

 =REGEXEXTRACT(source!A2,"^[\w\s\À-ÿ]+")

where

 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
1  
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
add comment

2 Answers

up vote 1 down vote accepted

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

^[\w\s\\À-ÿ-’']+ 

so double escaping seems to be required in this case

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.