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
Splitter
Table
Text
Character.FromNumber
Character.ToNumber
Guid.From
Json.FromValue
Text.AfterDelimiter
Text.At
Text.BeforeDelimiter
Text.BetweenDelimiters
Text.Clean
Text.Combine
Text.Contains
Text.End
Text.EndsWith
Text.Format
Text.From
Text.FromBinary
Text.Insert
Text.Length
Text.Lower
Text.Middle
Text.NewGuid
Text.PadEnd
Text.PadStart
Text.PositionOf
Text.PositionOfAny
Text.Proper
Text.Range
Text.Remove
Text.RemoveRange
Text.Repeat
Text.Replace
Text.ReplaceRange
Text.Reverse
Text.Select
Text.Split
Text.SplitAny
Text.Start
Text.StartsWith
Text.ToBinary
Text.ToList
Text.Trim
Text.TrimEnd
Text.TrimStart
Text.Upper
Value.FromText
Time
Type
Uri
Values
Powered By GitBook
Text.BetweenDelimiters

Text.BetweenDelimiters

Text.BetweenDelimiters
function (optional text as nullable any, startDelimiter as text, endDelimiter as text, optional startIndex as nullable any, optional endIndex as nullable any) as nullable any

Description

Returns the portion of text between the specified startDelimiter and endDelimiter. An optional numeric startIndex indicates which occurrence of the startDelimiter should be considered. An optional list startIndex indicates which occurrence of the startDelimiter should be considered, as well as whether indexing should be done from the start or end of the input. The endIndex is similar, except that indexing is done relative to the startIndex.

Category

Text.Transformations

Examples

Get the portion of "111 (222) 333 (444)" between the (first) open parenthesis and the (first) closed parenthesis that follows it.
Text.BetweenDelimiters("111 (222) 333 (444)", "(", ")")
"222"
Get the portion of "111 (222) 333 (444)" between the second open parenthesis and the first closed parenthesis that follows it.
Text.BetweenDelimiters("111 (222) 333 (444)", "(", ")", 1, 0)
"444"
Get the portion of "111 (222) 333 (444)" between the second open parenthesis from the end and the second closed parenthesis that follows it.
Text.BetweenDelimiters("111 (222) 333 (444)", "(", ")", {1, RelativePosition.FromEnd}, {1, RelativePosition.FromStart})
"222) 333 (444"
Previous
Text.BeforeDelimiter
Next
Text.Clean
Last modified 3yr ago
Copy link
Outline
Text.BetweenDelimiters
Description
Category
Examples