A common question I get asked when people are merging values from a Google spreadsheet into a GDoc and/or PDF is how to format the values. So I have written this formatString() function.

For example if you wanted to use it in the createPdf() function the main for-loop would be replaced with:

for (;columnIndex < headerRow[0].length; columnIndex++) {
  var nextValue = formatString(activeRow[0][columnIndex])
  var header = headerRow[0][columnIndex]
  copyBody.replaceText('%' + header + '%', nextValue)
}