PQM.guide
Home
Sample Tables
Resources
Concepts
Functions by Category
  • Table.AddColumn
  • Table.AddIndexColumn
  • Table.Buffer
  • Table.ColumnNames
  • Table.Combine
  • Table.Distinct
  • Table.DuplicateColumn
  • Table.ExpandRecordColumn
  • Table.ExpandTableColumn
  • Table.FillDown
  • Table.FillUp
  • Table.FirstN
  • Table.FromRecords
  • Table.Group
  • Table.HasColumns
  • Table.IsEmpty
  • Table.LastN
  • Table.NestedJoin
  • Table.Pivot
  • Table.PrefixColumns
  • Table.Profile
  • Table.PromoteHeaders
  • Table.Range
  • Table.RemoveColumns
  • Table.RemoveDuplicates
  • Table.RenameColumns
  • Table.ReorderColumns
  • Table.ReplaceValue
  • Table.ReverseRows
  • Table.RowCount
  • Table.Schema
  • Table.SelectColumns
  • Table.SelectRows
  • Table.Skip
  • Table.Sort
  • Table.TransformColumns
  • Table.TransformColumnTypes
  • Table.Unpivot
  • Table.UnpivotOtherColumns

Text Functions

Functions for working with text (string) values.

  • Text.Combine
    Joins a list of text values into a single text value with an optional separator.
  • Text.Contains
    Returns true if a text value contains a specified substring.
  • Text.EndsWith
    Returns true if a text value ends with a specified substring.
  • Text.From
    Converts a value to its text representation.
  • Text.Length
    Returns the number of characters in a text value.
  • Text.Lower
    Converts all characters in a text value to lowercase.
  • Text.Proper
    Capitalizes the first letter of each word in a text value.
  • Text.Remove
    Removes all occurrences of specified characters from a text value.
  • Text.Replace
    Replaces all occurrences of a substring within a text value.
  • Text.Split
    Splits a text value into a list of text values using a specified separator.
  • Text.StartsWith
    Returns true if a text value starts with a specified substring.
  • Text.Trim
    Removes leading and trailing whitespace (or specified characters) from a text value.
  • Text.TrimEnd
    Removes trailing whitespace (or specified characters) from a text value.
  • Text.TrimStart
    Removes leading whitespace (or specified characters) from a text value.
  • Text.Upper
    Converts all characters in a text value to uppercase.