Saurabh Jain
-
Posts
1,724 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
Returns a second value from a DateTime value
-
Returns a minute value from a DateTime value.
-
Returns an hour value from a DateTime value.
-
Creates a Time from local, universal, and custom Time formats.
-
Returns a time value from a value.
-
Returns the end of the hour.
-
Returns the uppercase of a text value.
-
Removes any occurrences of the characters in trimChars from the start of the original text value.
-
Removes any occurrences of the characters specified in trimChars from the end of the original text value.
-
Removes any occurrences of characters in trimChars from text.
-
Returns a list containing parts of a text value that are delimited by any separator text values.
-
Returns a list containing parts of a text value that are delimited by a separator text value.
-
Reverses the provided text.
-
Returns a text value composed of the input text value repeated a number of times.
-
Returns a text value with first letters of all words converted to uppercase.
-
Returns a text value padded at the beginning with pad to make it at least length characters. If pad is not specified, whitespace is used as pad.
-
Returns a text value padded at the end with pad to make it at least length characters.
-
Returns the lowercase of a text value.
-
Returns a text value that is the result of joining all text values with each value separated by a separator.
-
Returns the original text value with non-printable characters removed.
-
Returns the portion of text between the specified startDelimiter and endDelimiter.
-
Returns the portion of text before the specified delimiter.
-
Returns the portion of text after the specified delimiter.
-
Returns a logical value indicating whether a text value substring was found at the beginning of a string.
-
Returns the first occurrence of a text value in list and returns its position starting at startOffset.
