Google表格查询语言:转义撇号 [英] Google Sheets Query Language: escape apostrophe
本文介绍了Google表格查询语言:转义撇号的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
以下是我的函数:
<$>
如何在Google表格中的SQL查询中转义撇号? (QUERY)(QUERY(IMPORTRANGE(XXXXXXX,XXXXXX!A1:C),SELECT * WHERE Col2 ='Woman's blabla:blablabla'),SELECT Col1,Col2 )
我尝试添加另一个撇号:
= QUERY(QUERY(IMPORTRANGE(XXXXXXX,XXXXXX!A1:C),SELECT * WHERE Col2 ='Woman''s blabla:blablabla') ,SELECT Col1,Col2)
没有运气..我尝试了一个反斜杠,没有好运:
= QUERY(QUERY(IMPORTRANGE(XXXXXXX,XXXXXX!A1:C), SELECT * WHERE Col2 ='Woman /'blabla:blablabla'),SELECT Col1,Col2)
编辑:文档的语言环境是英国。
解决方案
尝试使用双引号带撇号的单词
SELECT * WHERE C ol2 =女人的blabla:blablabla
How can I escape an apostrophe inside a SQL query in Google Sheets?
Here's my function:
=QUERY(QUERY(IMPORTRANGE("XXXXXXX", "XXXXXX!A1:C"),"SELECT * WHERE Col2 = 'Woman's blabla: blablabla'"),"SELECT Col1, Col2")
I've tried adding another apostrophe:
=QUERY(QUERY(IMPORTRANGE("XXXXXXX", "XXXXXX!A1:C"),"SELECT * WHERE Col2 = 'Woman''s blabla: blablabla'"),"SELECT Col1, Col2")
No luck.. and I've tried putting a backslash, no luck as well:
=QUERY(QUERY(IMPORTRANGE("XXXXXXX", "XXXXXX!A1:C"),"SELECT * WHERE Col2 = 'Woman/'s blabla: blablabla'"),"SELECT Col1, Col2")
EDIT: The locale of the document is UK.
解决方案
Try using double quotes around the word with the apostrophe
"SELECT * WHERE Col2 = ""Woman's blabla: blablabla"" "
这篇关于Google表格查询语言:转义撇号的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文