Text

Text Module

Text.Alphabet

The alphabet

Text.AlphaNumeric

The alphabet and digits

Text.IsUpperCase

Is text all uppercase? returns false if any non-alpha characters are present

Text.IsAlpha

Text.RemoveExtraWhitespace

Text.SplitCamelCase

Splits camelCased and PascalCased text and separates by a space. Ex: "thisIsAColumn" -> "this Is A Column"

Text.SplitOnNotIn

Text.SplitOnNonAlpha

Text.Substring

Text.IsNumber

Text.PositionAfter

Text.Until

Text.AsciiOnly

Filters out all non-ascii characters from a string

Text.Between

Grabs the substring between the specified 'after' and 'before' strings

Text.ContainsAny

Check if a string contains any of the keywords from a given list

Text.Count

Returns the number of occurrences of a substring (needle) within another string (haystack).

Text.EachBetween

Grabs the substring between the specified 'after' and 'before' strings

Text.EachFromTo

Grabs the substring between the specified 'after' and 'before' strings

Text.FromTo

Grabs the first substring from the specified 'From' up to the 'UpTo' string

Text.Like

Allows doing fuzzy string comparisons akin to SQL's LIKE

Text.PowerTrim

Function removes double presents of specified characters.By default remove double spaces and leading + ending spaces. Like TRIM function in Excel

Text.RemoveSymbols

Remove all uicode symbols from text

Text.ReplaceAll

Do multiple text replacements in one function call, passing the replacements as a list of lists