REGEXEXTRACT and French accents in Google Sheets

Question

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?

Answer 1

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

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

so double escaping seems to be required in this case

Answer 2

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).

Answer 3

Another option is to Find ((.+)\s\(.+)/Replace($1) on a copy:

_{Always best to avoid dealings with French characters.}