Skip to content
Variables Substitution
Share
Explore

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):
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
0
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.