Connect Formatting to PostgreSQL

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

Execute a custom PostgreSQL query. See our docs to learn more about working with SQL in Mazaal AI.

Deletes a row or rows from a table. See the documentation

Finds a row in a table via a lookup column. See the documentation

Finds a row in a table via a custom query. See the documentation

Adds a new row. See the documentation

Retrieves available options for the Schema field.

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Updates an existing row. See the documentation

Adds a new row or updates an existing row. See the documentation