Connect Formatting to Zoho Sheet

Convert an object to a JSON format string

Parse a JSON string

Add or subtract time from a given input

Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

Format a date string to another date string. For more examples on formatting, see the Sugar Date Format documentation.

Format a number as a currency

Format a number to a new style. Does not perform any rounding or padding of the number.

Convert valid HTML to Markdown text

Convert valid HTML to text

Convert Markdown text to HTML

Decode a URL string

Encode a string as a URL

Find a match for a regular expression pattern. Returns all matched groups with start and end position.

Find an email address out of a text field. Finds the first email address only.

Find a number out of a text field. Finds the first number only.

Find a complete phone number out of a text field. Finds the first number only.

Find a web URL out of a text field. Finds the first URL only.

Replace all instances of any character, word or phrase in the text with another character, word or phrase.

Return a default value if the text is empty

Split the text on a character or word and return one or all segments

Transform case for a text input

Removes leading and trailing whitespace

Creates a new row in the specified worksheet. See the documentation

Retrieves available options for the Worksheet field.

Searches for a row based on provided criteria and deletes it. See the documentation

Finds a specific row by its index and updates its content. See the documentation