Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- * Replaces {{placeholders}} in sentance(s).
- *
- * @param {A1:C1} headers The headers.
- * @param {A2:C10} header_values The values below the headers.
- * @param {D2:D10} sentence The text with the headernames placeholders
- * @return {array} Replaces sentence(s)
- * @customfunction
- */
- function TEXT_REPLACE(headers, header_values, sentence) {
- if (!Array.isArray(headers)) {
- headers = [headers]
- }
- headers = headers.flat()
- if (!Array.isArray(header_values)) {
- header_values = [[header_values]]
- }
- if (!Array.isArray(sentence)) {
- sentence = [sentence]
- }
- sentence = sentence.flat()
- const results = [];
- sentence.forEach((s, i) => {
- if (s == "") {
- results.push([null])
- return;
- }
- headers.forEach((h, j) => {
- const key = `{{${h}}}`
- s = s.replace(key, header_values[i][j])
- })
- results.push([s])
- })
- return results
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement