哈喽,我又来啦! 碰到一个问题,在线求教如何解决: 使用Forms递交一份调查问卷,获取问卷内的附件地址后写入excel表格内,得到如下一长串代码: 我的需求是提取''https://...''里面的链接就好了,不要这么长的字符串。 "Attachment": "[{\"name\":\"DSM Oven Heat Recovery System G_anonymous.pdf\",\"link\":\https://mydrive.xxxx.com/personal/syyyy_xxxx_com/Documents/Apps/Microsoft%20Forms/ABC%20STC%20Action%20Register%20Updating/%E9%97%AE%E9%A2%98/DSM%20Oven%20Heat%20Recovery%20System%20G_anonymous.pdf\,\"id\":\"01F7D5LZ25ZNCJGH5RG3KTCLZP\",\"type\":null,\"size\":140873,\"referenceId\":\"01F7D5LZV46NH67C5TWFHZFPA2UZRAJ537\",\"driveId\":\"brJCnG3PdcUm9VK2YOw7CIOZLhgxBjZ5uTWVjnFvMnXElR6KuEWW0bQrv\",\"status\":1,\"uploadSessionUrl\":null}]"