Skip to content
A: you already provide your marked-up textB: you set a plain text and let the parser identify the replaceable words
Text Substitution [in-progress]
Enabling named-variable substitution in cell-text
The concept is similar to formula, but it allows to create named variables - instead of strict numeric sequences.
There are two use cases (reflected on column names):
You can decide what kind of markup you prefer (and even create your own!).
It also support case-sensitiveness.
Disclaimer:
Please, note that the the substitution relies on RegexExtract() formula which is not currently supported (hopefully, it will be), therefore is strongly discouraged to use this in critical contexts, as it might be discontinued.
Also, this is a playground document, subject to changes and incomplete.
Text
A.1 Markup Content
A.2 Converted
B.1 Plain Text
B.2 Markup Words
B.3 Converted
Markup Configuration
This is a {test} containing some {var} that will be replaced by this {tool}.
This is a sample text containing some named variables that will be replaced by this regex-converter.
This is a TEST containing some var that will be replaced by this tool.
This is a {TEST} containing some {var} that will be replaced by this tool.
This is a sample text containing some named variables that will be replaced by this tool.
Curly/i
This is a $test containing some $var that will be replaced by this $tool.
This is a sample text containing some named variables that will be replaced by this regex-converter.
This is a test containing some var that will be replaced by this tool.
This is a $test containing some $var that will be replaced by this tool.
This is a sample text containing some named variables that will be replaced by this tool.
Dollar
There are no rows in this table
To be addressed: non alphanumeric chars in - or adjacent - variables for plain text (see column B.2)
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.