Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Replacer.ReplaceText
Replacer.ReplaceValue
Splitter
Table
Text
Time
Type
Uri
Values
Powered By
GitBook
Replacer.ReplaceText
Replacer.ReplaceText
Replaces text within the provided input.
function (optional
text
as nullable any,
old
as text,
new
as text) as nullable any
Description
Replaces the
old
text in the original
text
with the
new
text. This replacer function can be used in
List.ReplaceValue
and
Table.ReplaceValue
.
Category
Replacer
Examples
Replace the text "hE" with "He" in the string "hEllo world".
1
Replacer.ReplaceText("hEllo world","hE","He")
Copied!
"Hello world"
Previous
Replacer
Next
Replacer.ReplaceValue
Copy link
Contents
Replacer.ReplaceText
Description
Category
Examples