doulianxing4015 2018-06-29 20:30
浏览 642

如何使用Sprintf对YAML文件采用的字符串中的单引号进行转义

I'm using Go but I'm having issues while trying to get an array that contains a single quote, I'm making a query structure to create a .sql file with that query, the issue is with an array field that is adding double quotes instead of a single quote.

This is what I have:

Yaml File:

Name: 'Myname'
Age: 9
Dimensions ['go', 'lang']

Go code Syntaxis:

var Query string = "";
Query = fmt.Sprintf("INSERT INTO persons (name, age, dimensions) VALUES ('%s', %d, %q)")

OUTPUT:

 Query:
 INSERT INTO persons (name, age, dimensions) VALUES ('MyName', 9, ["go", "lang"])

I don't want "go" and "lang" double quoted, I want it as the YAML file came, with single quote.

Is supposed that "%q" escape the single quote...

any idea what to do?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 keil的map文件中Image component sizes各项意思
    • ¥30 BC260Y用MQTT向阿里云发布主题消息一直错误
    • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
    • ¥15 划分vlan后,链路不通了?
    • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
    • ¥15 Vue3 大型图片数据拖动排序
    • ¥15 Centos / PETGEM
    • ¥15 划分vlan后不通了
    • ¥20 用雷电模拟器安装百达屋apk一直闪退
    • ¥15 算能科技20240506咨询(拒绝大模型回答)