Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation

Saurabh Jain

Administrators
  • Posts

    1,724
  • Joined

  • Last visited

  • Days Won

    61

Everything posted by Saurabh Jain

  1. Returns the first occurrence of substring in a string and returns its position starting at startOffset.
  2. Returns a logical value indicating whether a text value substring was found at the end of a string.
  3. Returns true if a text value substring was found within a text value string; otherwise, false.
  4. Selects all occurrences of the given character or list of characters from the input text value.
  5. Replaces length characters in a text value starting at a zero-based offset with the new text value.
  6. Replaces all occurrences of a substring with a new text value.
  7. Removes count characters at a zero-based offset from a text value.
  8. Removes all occurrences of a character or list of characters from a text value. The removeChars parameter can be a character value or a list of character values.
  9. Returns a text value with newValue inserted into a text value starting at a zero-based offset.
  10. Saurabh Jain

    Text.End

    Returns the number of characters from the end of a text value.
  11. Returns the count of characters from the start of a text value.
  12. Returns a number of characters from a text value starting at a zero-based offset and for count number of characters.
  13. Returns the substring up to a specific length.
  14. Saurabh Jain

    Text.At

    Returns a character starting at a zero-based offset.
  15. Decodes a value from a textual representation, value, and interprets it as a value with an appropriate type. Value.FromText takes a text value and returns a number, a logical value, a null value, a DateTime value, a Duration value, or a text value. The empty text value is interpreted as a null value.
  16. Returns a list of characters from a text value.
  17. Encodes a text value into binary value using an encoding.
  18. Returns a Guid value as a text value.
  19. Decodes data from a binary value in to a text value using an encoding.
  20. Returns the text representation of a number, date, time, datetime, datetimezone, logical, duration or binary value. If a value is null, Text.From returns null. The optional culture parameter is used to format the text value according to the given culture.
  21. Produces a JSON representation of a given value.
  22. Returns a Guid.Type value from the given value.
  23. Returns a character to its number value.
  24. Returns a number to its character value.
  25. Returns the number of characters in a text value.
×
×
  • Create New...