Question

So I am running through a directory deriving names to insert into a MySQL database. Some of the names have a single quote ( ). I m using awk

ls *| awk -F=:  {print "INSERT into citation_sources (source_name) VALUES (" "   " $1 "   " ");"}

While I can get the output to appear properly from awk. E.G.:

INSERT into citation_sources (source_name) VALUES ( Black s Law Dictionary, 2nd Edition (Black 1891));

当将数据插入 MySQL I 的时间时, d 想要避免做第二次数据编辑以正确避免使用 < code> 的单引号。

我为我做这些在我的腹部错过了什么?

Answer 1

如果您没有古代的 ls , 请在参数列表中添加 - Q( 引用) :

$ ls -Q * | awk -F=:  {print "INSERT into citation_sources (source_name) VALUES (" "   " $1 "   " ");"} 
INSERT into citation_sources (source_name) VALUES ( "Black s Law Dictionary, 2nd Edition (Black 1891)" );

@shellter 指出, 这是你应该思考如何真正想要引用值的时候。

或者先通过斜线或相似的斜线管道,以获得(例如 sed "s,\\\,g" )。

光靠Awk逃跑解决它比人们想象的要狡猾得多,因为Bash吞噬了引言和逃逸。因此,产生出它是最具有挑战性的一小段,我最后却为了它的生存而制造出一代无助的贝壳:

$ ls * | awk -F=: "{print "INSERT into citation_sources (source_name) VALUES ( " gensub(" ",""$ \\ "\ ","global",$1) " );"}"
INSERT into citation_sources (source_name) VALUES ( Black s Law Dictionary, 2nd Edition (Black 1891) );

Answer 2

把这个放进你的小剧本里

echo "Black s Law D icti onary"|awk  {
ESC=sprintf("%c",0x5c);
SQ=sprintf("%c",0x27);
DQ=sprintf("%c",0x22);
# then perfrom a 
gsub(SQ,ESC""SQ);
# and such. same goes for other stuff.
}

简单到有:-)

友情链接