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
Last modified 3yr ago
Copy link
Contents
Replacer.ReplaceText
Description
Category
Examples