Skip to content
Gallery
Variables Substitution
Text Substitution [in-progress]
Variables
Configuration
More
Share
Explore

icon picker
Text Substitution [in-progress]

Enabling named-variable substitution in cell-text
Federico Stefanato
|
Federico Stefanato
The concept is similar to
Format()
⁠
formula, but it allows to create named variables - instead of strict numeric sequences.
There are two use cases (reflected on column names):
A: you already provide your marked-up text
B: you set a plain text and let the parser identify the replaceable words

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
1
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
2
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
3
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 & Curly
4
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.
Angular
5
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.
Square
6
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.
Round
7
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.
Hashtag
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.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.