google sheetsregexregexextract
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?
Only after having requested that the documents were to be shared with us, was I able to determine what's going on.
The response sheet is new Google Sheet proof:
The sheet, in which you want to pull the data in, doesn't have this mark.
You are trying to import the data via the complete URL (new Sheets style) from within an old Google Spreadsheet. This is where Google says: No Can Do !!
If you use the key instead, it works just fine:
=IMPORTRANGE("1zRHatplJ6AVUSWr1HXoycUrvtK05dw4-ZqeEYN1xJ4Y", "B:B")
See references for more information on this topic.
No, it's not possible to "skip columns".
Instead you could use two query functions, one to be used to get the columns A - C, the other to get the columns F and following.
First formula (A1):
=QUERY(
IMPORTRANGE("URL","Sheet Name!A2:P"),
"SELECT Col1,Col2,Col3
WHERE Col11 CONTAINS 'West'",
1
)
Second formula (F1):
=QUERY(
IMPORTRANGE("URL","Sheet Name!A2:P"),
"SELECT Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15
WHERE Col11 CONTAINS 'West'",
1
)
REMARKS:
Note that instead of Sheet Name!A2:P1000 was used Sheet Name!A2:P as this take the whole columns instead of only 1000 rows.
Best Answer
Well, I got it to work changing my expression to:
so double escaping seems to be required in this case