79556435
Date: 2025-04-05 00:53:25
Score: 0.5
Natty:
You can also use templated text and key-value replacements,
with either native functions or with a named-function.
| A | B | |
|---|---|---|
| 1 | Template Text => | 🔑1 was as tall as a 🔑2 🔑3 |
| 2 | Key-value pairs: | |
| 3 | 🔑1➜He | |
| 4 | 🔑2➜six-foot-three-inch | |
| 5 | 🔑3➜tree | |
| 6 | Formula : | Output: |
| 7 | =REDUCE(B1, A3:A5, LAMBDA(text, key_value, REGEXREPLACE(text, REGEXEXTRACT(key_value,"🔑\d+"), REGEXEXTRACT(key_value,"[^➜]+$")))) | He was as tall as a six-foot-three-inch tree |
As a named function:
TEMPLATE(template_text, key_value_pairs)
Reasons:
Posted by: M. Hoffman - Probably link only (1):
- Long answer (-0.5):
- Has code block (-0.5):
- Low reputation (0.5):