How to insert quote character (") as an element of URL in importXML function?

Question

My URL contains a quote character, and Google Spreadsheets see this as the end of the URL whereas it is not.

https://api.archives-ouvertes.fr/search/?fq=producedDateY_i:[2013 TO 2015]&fq=docType_s:"ART"&rows=0

How can I use an URL with ImportXML() that has a quote character in it?

Rubén - Volunteer Moderator - · Accepted Answer · 2016-09-14 12:24:39Z

1

Double the quote character, instead of " use """".

Another alternative is to put the URL alone on cell, lets say A1, then put the cell reference in your formula:

  =IMPORTXML(A1,"//div")

answered Sep 14, 2016 at 12:24

46.1k18 gold badges100 silver badges297 bronze badges

Add a comment |

Aurielle Perlmann · Accepted Answer · 2016-10-01 12:48:23Z

0

You can also encode your url. %22 is the encoded quotations:

https://api.archives-ouvertes.fr/search/?fq=producedDateY_i:[2013%20TO%202015]&fq=docType_s:%22ART%22&rows=0

answered Oct 1, 2016 at 12:48

Aurielle Perlmann

4,8791 gold badge15 silver badges21 bronze badges

Add a comment |

2 Answers 2