基于谷歌文档,我正在创建一个谷歌应用程序脚本,该脚本将谷歌文档表格中的可用文本插入谷歌工作表中。由于有时文本很长,在谷歌表单中插入的文本看起来不太好。也使用了sheet.autoResizeColumns(3,sheet.getLastColumn())
,但由于文本的长度,它看起来不太好。
所以我想在字符串文本的每个点后面添加一行。我尝试了testText = testText.replace('.','n')
,但这只是用一条新线替换了第一个点,还删除了这个点。我想要的是在整个字符串中的点之后有一条新线,这样就不会删除点。示例:
var testText = 'This approach is very good. Thank you very much for your Attention. We will send you messages.'
通缉文本:
var wantedText = 'This approach is very good.
Thank you very much for your Attention.
We will send you messages.'
如何在谷歌应用程序脚本中做到这一点?
请参阅https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals:使用反勾号(重音符(字符,而不是双引号或单引号
function literals(){
var wantedText = `This approach is very good.
Thank you very much for your Attention.
We will send you messages.`
Logger.log(wantedText)
}
如果文本来自单元格,请使用:
function breakLine(){
var testText = 'This approach is very good. Thank you very much for your Attention. We will send you messages.'
var wantedText = testText.replace(/(.)/gm,".n");
Logger.log(wantedText)
}
如有必要,在点后添加一个空格
var wantedText = testText.replace(/(. )/gm,".n");