Skip to content

Variables Substitution

Text Substitution [in-progress]

More

Share

Explore

Text Substitution [in-progress]
Text Substitution [in-progress]

Enabling named-variable substitution in cell-text

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

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.