Only this pageAll pages
Powered by GitBook
1 of 25

Text

Text

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Overview

Learn how to manipulate text in your automations.

Getting Started

To begin automating in this category, follow the guides below. Use the provided examples and syntaxes to add the procedures to your automations.

Text Automation Procedures

Boolean ChecksConversionsCombine TextsExtract Markdown HeadingsExtract Elements from TextGet Text LengthRemovalReplacementSplitting

Boolean Checks

Automation procedures for evaluating text conditions that yield either a "true" or "false" result.

Check Text End

Check if a text ends with another text value.

Overview

This operation checks if a text ends with another text value. It acts as a conditional check, allowing you to perform additional operations depending on the truth of the statement.

Syntax

This operation has two different formats:

Option 1

Option 2

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter
Description
Examples
Required

Examples

1. Using "is ended by"

2. Using "is terminated by"

the text

Yes

input

A text value.

Have a good day

Yes

suffix

A text string value to check against the end of another string.

day

Yes

action

An operation that occurs if input ends with suffix.

say "Thanks!"

Yes

the text is "{input}"
if the text is terminated by "{suffix}" then
    {action}
the text is "{input}"
if the text is ended by "{suffix}" then
    {action}
the statement is "Processing complete!"
if the statement is ended by "complete!" then
  say "All tasks are finished!"
All tasks are finished!
the greeting is "Welcome to Kognitos!"
if the greeting is terminated by "Kognitos!" then
  say "Let's start automating!"
Let's start automating!

Removal

Automation procedures involving text removal.

Check Text Start

Check if a text is started by another text value.

Overview

This operation checks if a given text's starting characters match another text value. It acts as a conditional check, allowing you to perform additional operations depending on the statement's truth.

Syntax

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter
Description
Examples
Required

Examples

Convert Text to HTML

Create an HTML file by converting text to HTML.

Overview

This operation accepts valid HTML text as input and generates an HTML file.

Syntax

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter
Description
Example
Required

Examples

Check Text Contents

Check if a value is present within a text.

Overview

This operation checks if a particular value (such as a string, float, or integer) exists within a text. It acts as a conditional check, allowing you to perform additional operations based on whether the value exists.

Syntax

the text is "{input}"
if the text is started by "{prefix}" then
    {action}
the text is "{input}"
convert the text to an html file

the text

Yes

input

Text containing valid formatted HTML.

<html><body>Hello, world!</body></html>

Yes

the text is "<html><body>Hello, world!</body></html>"
convert the text to an html file
An .html file that contains 'Hello, world!'

Conversions

Automation procedures that transform text from one format or structure to another.

the text

Yes

input

A text value.

Good morning!

Yes

prefix

A text value to check against the start of the string.

Good

Yes

action

An operation that occurs if input starts with prefix.

say "Thanks!"

Yes

the sentence is "Good morning, everyone!"
if the sentence is started by "Good" then
    say "Rise and shine!"
Rise and shine!
Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

the text

Yes

the object

Yes

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter
Description
Examples
Required

target

The target text in which the search is performed.

  • Batch job completed.

  • Error code: 404

  • document.txt

  • The value of Ï€ (pi) is approximately 3.14.

Yes

value

The value to search for (text, float, or integer).

  • job completed

  • 404

  • .txt

  • 3.14

Yes

action

An operation that occurs if value is present in target.

  • say "The format is valid."

Examples

1. Validating a File Extension

2. Check for a Specific Error Code

Splitting

Split a text into smaller texts.

Overview

This operation splits a given text into smaller texts. A delimiter can be specified to define where the text should be divided.

Syntax

Two syntaxes are supported for this operation.

Option 1

Option 2

In this syntax, the parts of the text that are split can be further referenced via the parts.

Specifying a Delimiter (Optional)

Optionally, the delimiter can be specified to split the text. By default, a space is used as the delimiter.

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameters
Description
Examples
Required

Examples

1. Split a Title

No delimiter is specified in this example, so a space is used by default.

2. Split an Email

In this example, a delimiter is specified.

Convert Text to Lowercase

Convert a given text to lowercase format.

Overview

This operation takes input text and converts it to lowercase. It’s useful for standardizing text input and making it consistent for display and comparison purposes.

  • "HELLO WORLD" → hello world

  • "This is a sample text" → this is a sample text

Syntax

1. Option 1

This syntax uses an explicit get.

2. Option 2

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter
Description
Examples
Required

Examples

1. Lowercasing an Address

This example converts the address "123 Main STREET" to lowercase, resulting in "123 main street".

2. Lowercasing a Name

This example converts the name "JANE DOE" to lowercase, resulting in "jane doe."

the file name is "document.txt"
the extension is ".txt"
if the extension is in the file name then
  say "The format is valid."
The format is valid.
the status log is "Batch job completed with errors. Error code: 404."
the error code is "404"
if the error code is in the status log then
  say "Cannot proceed."
Cannot proceed.
the text is "{target}"
the object is "{value}"
if the object is in the text then
 {action}

Yes

the text

Yes

the delimiter

No

the parts

No

input

The text to be split.

How to Build Your Automation

Yes

delimiter

A character or sequence of characters used to split the text. Default delimiter is a space, if not specified.

  • @

  • ;

  • ,

Optional

the text

Yes

input

The text string that needs to be converted to lowercase.

123 Main STREET

Yes

the text is "{input}"
split the text
the text is "{input}"
split the text into parts
the text is "{input}"
split the text into parts
    the delimiter is "{delimiter}"
the title is "How to Build Your Automation"
split the title
How
to
Build
Your
Automation
the email is "[email protected]"
split the email
    the delimiter is "@"
user
domain.com
the text is "{input}"
get the text's lowercase
the text is "{input}"
the text's lowercase
the address is "123 Main STREET"
get the address's lowercase
123 main street
the name is "JANE DOE"
the name's lowercase
jane doe

Replacement

Replace a text with another text.

Overview

This operation lets you replace occurrences of a specific text with a new text. For instance, consider the following sentence:

The dog jumped over the curb and then the dog sprinted away.

Using this operation, you can replace all instances of dog with cat, resulting in:

The cat jumped over the curb and then the cat sprinted away.

Syntax

This operation supports both of the following syntaxes:

Option 1

Option 2

Note: Specifying the replacement strategy is optional. By default, all occurrences are replaced.

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameters
Description
Examples
Required

Examples

1. Replace all occurrences

2. Replace the first occurrence

Convert Number to Character

Convert a number into its corresponding character ASCII value.

Overview

This operation converts a numeric value into its corresponding character based on the ASCII table. ASCII is a standard encoding scheme where numbers represent specific characters, such as letters, digits, and symbols.

Syntax

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter
Description
Examples
Required

Examples

Convert Character to Number

Convert a character into its corresponding numeric ASCII value.

Overview

This operation allows you to convert a single character into its corresponding numeric value based on the ASCII table. ASCII is a standard encoding scheme where numbers represent specific characters, such as letters, digits, and symbols.

Syntax

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter
Description
Example
Required

Examples

Convert Text to Titlecase

Convert a given text to title case.

Overview

This operation converts a given string to title case, meaning that the first letter of each word in the string is capitalized, while other words remain lowercase.

  • "hello world" → Hello World

  • "this is a sample text" → This Is A Sample Text

Syntax

This operation supports two alternative formats.

Option 1

This syntax uses an explicit get.

Option 2

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameter
Description
Examples
Required

Examples

1. Get Article Name in Title Case

2. Get Airline in Title Case

Remove Text Using Substrings

Removes a specific piece of text from a larger text.

Overview

This operation allows you to edit a text by specifying a piece of text ("a substring") to remove. You can optionally define the strategy to remove the substring's first, last, or all occurrences in the larger text.

Syntax

Convert Text to Uppercase

Convert a given text to uppercase.

Overview

This operation takes a string as input and returns its uppercase equivalent. It’s useful for standardizing text formats, especially when dealing with case-sensitive data.

  • "hello world" → HELLO WORLD

Get Text Length

Get the length of a text string.

Overview

This operation calculates a string's length by counting the total number of characters, including letters, numbers, spaces, and symbols. It is useful for validating input lengths and analyzing text.

Syntax

the number is {value}
convert the number to a character

the number

No

value

The numeric value to convert.

97

Yes

the number is 97
convert the number to a character
a

strategy

The method for replacing matches of the substring. Accepted values:

  • first- Removes the first occurrence. (default)

  • last - Removes the last occurrence.

  • all - Removes all occurrences.

all

Optional

the text

Yes

the replacement strategy

No

input

The input text where replacements will occur.

The dog jumped over the curb and then the dog sprinted away.

Yes

substring

The section of the text to be replaced.

dog

Yes

replacement

The replacement value.

cat

Yes

the character

No

input

A single character to convert to a number.

A

Yes

the character is "A"
convert the character to a number
65

the text

Yes

input

The input text to be converted to title case.

  • hello world

  • this is a sample text

Yes

Optional: Specifying a Remove Strategy

Optionally, you can specify a remove strategy using the where keyword. This specifies which occurrences of the second text to remove:

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

the text1

Yes

the text2

Yes

the remove strategy

No

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

text1 value

The target text.

"The dog barked."

Yes

text2 value

The text to be removed from the target string.

"dog"

Yes

strategy

The removal strategy. There is no default. Accepted values:

  • first - Removes the first occurrence.

  • last - Removes the last occurrence.

  • all - Removes all occurrences.

"all"

Optional

Examples

1. Remove all occurrences

2. Remove the first occurrence

3. Remove the last occurrence

4. No removal strategy specified

This will Raise a Question and prompt you to choose which value to remove.

Multiple: "dog"s in: "The quick brown fox jumps over the lazy dog. The dog barked." Which one do you want to remove?

"This is a sample text" → THIS IS A SAMPLE TEXT

Syntax

Option 1

This syntax uses an explicit get.

Option 2

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

the text

Yes

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameter
Description
Examples
Required

input

The input text to be converted to uppercase.

aa1234

Yes

Examples

1. Uppercasing a Flight Number

2. Uppercasing a Promo Code

This operation supports two alternative formats. It works with and without an explicit get.

Option 1

Option 2

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

the text

Yes

Parameters

Parameter
Description
Examples
Required

input

The input text whose length will be calculated.

"Happy Holidays!"

Yes

Examples

the text is "{input}"
replace "{substring}" with "{replacement}" in the text
  the replacement strategy is "{strategy}"
the text is "{input}"
replace "{substring}" in the text where
    the replacement is "{replacement}"
    the replacement strategy is "{strategy}"
the text is "The dog jumped over the curb and then the dog sprinted away."
replace "dog" with "cat" in the text
The cat jumped over the curb and then the cat sprinted away.
the text is "The dog jumped over the curb and then the dog sprinted away."
replace "dog" with "cat" in the text
  the replacement strategy is "first"
The cat jumped over the curb and then the dog sprinted away.
the character is "{input}"
convert the character to a number
the text is "{input}"
get the text's titlecase
the text is "{input}"
the text's titlecase
the article name is "ultimate guide to automation"
get the article name's titlecase
Ultimate Guide To Automation
the airline is "skyswift airways"
the airline's titlecase
Skyswift Airways
the input text is "The quick brown fox jumps over the lazy dog. The dog barked."
the focus word is "dog"
remove the focus word from the input text where
  the remove strategy is "all"
The quick brown fox jumps over the lazy . The barked.
the input text is "The quick brown fox jumps over the lazy dog. The dog barked."
the focus word is "dog"
remove the focus word from the input text where
  the remove strategy is "first"
The quick brown fox jumps over the lazy . The dog barked.
the input text is "The quick brown fox jumps over the lazy dog. The dog barked."
the focus word is "dog"
remove the focus word from the input text where
  the remove strategy is "last"
The quick brown fox jumps over the lazy dog. The barked.
the input text is "The quick brown fox jumps over the lazy dog. The dog barked."
the focus word is "dog"
remove the focus word from the input text
the text1 is "{text1 value}"
the text2 is "{text2 value}"
remove the text2 from the text1
the text1 is "{text1 value}"
the text2 is "{text2 value}"
remove the text2 from the text1 where
 the remove strategy is "{strategy}"
the flight number is "aa1234"
the flight number's uppercase
AA1234
the promo code is "save20"
get the promo code's uppercase
SAVE20
the text is "{input}"
get the text's uppercase
the text is "{input}"
the text's uppercase
the title is "Booking Report"
get the title's length
14
the greeting is "Happy Holidays!"
the greeting's length
15
the text is "{input}"
the text's length
the text is "{input}"
get the text's length

Extract Markdown Headings

Extract headings from a given markdown text.

Overview

This operation identifies and extracts headings from markdown text. Markdown headings are identified by the # symbol followed by a space and then the heading text.

Syntax

Data

The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

Data Name
Can Be Renamed

Parameters

Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

Parameters
Description
Examples
Required

Examples

Tip: Use the Markdown Widget

To add multi-line markdown content, type "/" and select markdown. This opens a markdown editor where you can easily type and format your text.

Combine Texts

Combine a list of text values using a specified separator.

Overview

This operation allows you to combine multiple text values into a single text, with each value separated by a specified character or symbol (e.g., a comma, semicolon, or dash). For example:

  • Separated by a comma:Red, Green,

the markdown text is "{input}"
extract headings from the markdown text

the markdown text

No

headings

No

input

The markdown text containing headers to be extracted.

Title

This is a subheader.

Yes

the markdown text is "# Title \n This is a sample subtitle."
extract headings from the markdown text
# Title
Blue
->
Red, Green, Blue
  • Separated by a colon: Monday, 3:00 PM -> Monday: 3:00 PM

  • Separated by a space: John, Smith -> John Smith

  • Syntax

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    the texts

    Yes

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameter
    Description
    Examples
    Required

    list of texts

    The list of texts to be combined.

    "apples", "bananas", "oranges"

    Yes

    separator

    The type of separator. Acceptable values:

    • comma

    • semicolon

    • colon

    • tab

    comma

    Yes

    Examples

    1. Combining Error Messages

    2. Joining Items in a Shopping List

    Check Regex Match

    Check if a text matches a regular expression pattern.

    Overview

    This operation checks if a text conforms to a regular expression pattern. It serves as a conditional check, allowing you to perform additional operations depending on the truth of the statement.

    Syntax

    This operation has two different formats. You can use either is matched by or matches to refer to the regular expression check.

    1. Option 1

    2. Option 2

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameter
    Description
    Examples
    Required

    Examples

    1. Validate Username Format

    Remove Text Using Regex

    Removes occurrences of a specified regular expression from a text.

    Overview

    This operation lets you clean a text by removing all or specific occurrences of a regular expression pattern. You can optionally define the strategy to either remove the first occurrence, the last occurrence, or all occurrences of the matched pattern in the text.

    Syntax

    the error messages are "Error Code 404", "Page Not Found"
    get the error messages with a colon
    Error Code 404: Page Not Found
    the shopping list items are "apples", "bananas", "oranges"
    get the shopping list items with a comma
    apples, bananas, oranges
    the texts are {list of texts}
    get the texts with a {separator}

    newline

    the text

    Yes

    the regular expression

    No

    input

    An input text to be checked against the regular expression.

    • user123

    • Welcome to Kognitos.

    Yes

    regex

    A regular expression that defines the criteria the text must match.

    • ^[a-zA-Z0-9]+$

    • ^\d3$

    Yes

    action

    An operation that occurs if input conforms to the regular expression.

    • say "The username contains only letters and numbers."

    Yes

    This operation supports both of the following syntaxes:

    Option 1

    This syntax defines the text as data.

    Option 2

    Note: Specifying a remove strategy is optional. By default, all matching occurrences are removed.

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can be Renamed

    the text

    Yes

    the regular expression

    No

    the remove strategy

    No

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    input

    The text to be cleaned.

    The order number is 12345.

    Yes

    regex

    The regular expression pattern to be removed.

    [0-9]+

    Yes

    strategy

    The removal strategy. Accepted Values:

    • first - Removes the first occurrence.

    • last - Removes the last occurrence.

    • all - Removes all occurrences. (default)

    all

    Optional

    Examples

    1. No removal strategy specified

    In this example, no removal strategy is specified, so all matching occurrences are removed by default.

    2. Removing the first occurrence

    3. Removing the last occurrence

    the text is "{input}"
    the regular expression is "{regex}"
    if the text matches the regular expression then
     {action}
    the text is "{input}"
    the regular expression is "{regex}"
    if the text is matched by the regular expression then
     {action}
    the username is "user123"
    the regular expression is "^[a-zA-Z0-9]+$"
    if the username matches the regular expression then
      say "The username contains only letters and numbers."
    The username contains only letters and numbers.
    the regular expression is "[0-9]+"
    remove the regular expression from "The order number is 12345."
    The order number is .
    the text is "The order number is 12345, and the reference ID is 67890."
    the regular expression is "[0-9]+"
    remove the regular expression from the text
      the remove strategy is "first"
    The order number is , and the reference ID is 67890.
    the text is "The order number is 12345, and the reference ID is 67890."
    the regular expression is "[0-9]+"
    remove the regular expression from the text
      the remove strategy is "last"
    The order number is 12345, and the reference ID is .
    the text is "{input}"
    the regular expression is "{regex}"
    remove the regular expression from the text
     the remove strategy is "{strategy}"
    the regular expression is "{regex}"
    remove the regular expression from "{input}"
     the remove strategy is "{strategy}"

    Extract Elements from Text

    Extract lines, words, characters, URLs, numbers, or patterns from a text.

    Overview

    This collection of operations is used to extract specific elements from a text, including lines, words, characters, URLs, numbers, and patterns.

    1. Extract Words

    This operation extracts individual words from a text. A word is a contiguous collection of characters delimited by a space.

    Syntax

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameter
    Description
    Example
    Required

    Example


    2. Extract Lines

    This operation extracts individual lines from a text. A line refers to a single row of text that is typically separated by a line break or new line character.

    Syntax

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameter
    Description
    Example
    Required

    Example


    3. Extract Characters

    This operation extracts individual characters from a text.

    Syntax

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameter
    Description
    Example
    Required

    Example


    4. Extract URLs

    This operation extracts URLs from a text.

    Syntax

    Note: The terms url(s) or URL(s) can be used in any case and in either singular or plural form.

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameter
    Description
    Example
    Required

    Example

    Notes

    Implementation Detail: This is the regular expression used internally to find URLs in a given text: ((http|https)://)?\[a-zA-Z0-9./?:@-_\=#]+.(\[a-zA-Z]){2,6}(\[a-zA-Z0-9.&/?:@-_\=#])\*


    5. Extract Numbers

    This operation extracts numbers from a text.

    Syntax

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameter
    Description
    Example
    Required

    Example


    6. Extract Substring

    This operation extracts substrings from a text.

    Syntax

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameter
    Description
    Examples
    Required

    Example

    Convert Text to Number

    Convert a text representation of a number into its numeric value.

    Overview

    This operation takes a text representing a number and converts it into a numeric value. It also recognizes and converts certain characters that resemble numbers, ensuring accurate interpretation of numeric values, including those written in European notation or with unconventional characters. See the notes for details.

    Syntax

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameter
    Description
    Examples
    Required

    Examples

    1. Converting a Whitespace-Affected Number Text

    2. Converting a Decimal String to a Number

    Notes

    Additional Character-to-Number Mappings

    This table defines additional character-to-number mappings, extending the standard set of conversions. It includes common characters and symbols that are translated to their corresponding numeric values.

    Characters
    Numeric Equivalent

    European Decimal Notation

    This operation properly parses decimal numbers in European notation, where commas are used as decimal separators. It automatically converts numbers like "12.345,67" into the format "12345.67" for processing.

    the text

    Yes

    input

    The input text.

    She quickly ran to the store.

    Yes

    the text

    Yes

    input

    The input text.

    The quick brown fox jumps over the lazy dog. It loves to run fast. The dog watches quietly. Both enjoy the open field.

    Yes

    the text

    Yes

    input

    The input text.

    Be kind

    Yes

    the text

    Yes

    input

    The input text.

    Visit our website at https://www.example.com

    Yes

    the text

    Yes

    input

    The input text.

    There are 150 apples and 35 oranges in the basket.

    Yes

    the text

    Yes

    input

    The input text.

    The order number is ORD123456 and should be processed by tomorrow.

    Yes

    pattern

    A regular expression to match.

    ORD[0-9]+

    Yes

    the sentence is "She quickly ran to the store."
    get the sentence's words
    She
    quickly
    ran
    to
    the
    store.

    €

    6

    the text

    Yes

    input

    The text that represents a number which needs to be converted.

    • "100"

    • "3.14"

    Yes

    O, o

    0

    !, I, i

    1

    E

    3

    S, s, $

    5

    T, t

    7

    B

    8

    the text is "{input}"
    get the text's words
    the text is "{input}"
    get the text's lines
    the paragraph is "The quick brown fox jumps over the lazy dog. \n It loves to run fast. \n The dog watches quietly. \n Both enjoy the open field."
    get the paragraph's lines
    The quick brown fox jumps over the lazy dog.
    It loves to run fast.
    The dog watches quietly.
    Both enjoy the open field.
    the text is "{input}"
    get the text's characters
    the saying is "Be kind"
    get the saying's characters
    B
    e
     
    k
    i
    n
    d
    the text is "{input}"
    get the text's URLs
    the subheader is "Visit our website at https://www.example.com"
    get the subheader's url
    https://www.example.com
    the text is "{input}"
    get the text's numbers
    the sentence is "There are 150 apples and 35 oranges in the basket."
    get the sentence's numbers
    150
    35
    the text is "{input}"
    get the text's substrings which match "{pattern}"
    the text is "The order number is ORD123456 and should be processed by tomorrow."
    get the text's substrings which match "ORD[0-9]+"
    ORD123456
    the text is "{input}"
    get the text as a number
    the value is "  98  "
    get the value as a number
    98
    the decimal is "3.14"
    get the decimal as a number
    3.14

    Convert Text Date to ISO Format

    Convert a given text date to ISO-8601 format.

    Overview

    This procedure takes a text date and converts it to ISO-8601 format.

    Syntax

    Optional: Specifying the Timezone

    Optionally, you can specify a to be used during the conversion. If not specified, the system’s default timezone is used.

    Data

    The table below lists the names of the data elements in this operation and indicates which can be renamed in the syntax.

    Data Name
    Can Be Renamed

    Parameters

    Parameters are placeholders for data. Refer to the table below for details on each parameter in this operation. In the syntax, replace parameters with your own values.

    Parameters
    Description
    Examples
    Required

    Examples

    1. Converting a Date in 'Month Day, Year' Format

    2. Converting a Date in 'Month/Day/Year' Format

    3. Specifying a Timezone

    Timezones

    This is a complete list of all the currently supported timezones.

    the date is "{input}"
    convert the date to iso format

    the date

    No

    the department's zone

    No

    input

    The text date to be converted, in any format.

    • "December 1, 2024"

    • "12/01/2024"

    • "01.12.2024"

    Yes

    timezone

    The timezone to be used for conversion. If not provided, the system’s default timezone will be used.

    • America/New_York

    • Asia/Shanghai

    • Pacific/Honolulu

    Optional

    timezone
    the date is "{input}"
    the department's zone is "{timezone}"
    convert the date to iso format
    the date is "December 11, 2024"
    convert the date to iso format
    2024-12-11T00:00:00-05:00
    the date is "12/11/2024"
    convert the date to iso format
    2024-12-11T00:00:00-05:00
    the date is "12/01/2024"
    the department's zone is "America/New_York"
    convert the date to iso format
    2024-12-01T00:00:00-05:00
    Africa/Abidjan
    Africa/Accra
    Africa/Addis_Ababa
    Africa/Algiers
    Africa/Asmara
    Africa/Asmera
    Africa/Bamako
    Africa/Bangui
    Africa/Banjul
    Africa/Bissau
    Africa/Blantyre
    Africa/Brazzaville
    Africa/Bujumbura
    Africa/Cairo
    Africa/Casablanca
    Africa/Ceuta
    Africa/Conakry
    Africa/Dakar
    Africa/Dar_es_Salaam
    Africa/Djibouti
    Africa/Douala
    Africa/El_Aaiun
    Africa/Freetown
    Africa/Gaborone
    Africa/Harare
    Africa/Johannesburg
    Africa/Juba
    Africa/Kampala
    Africa/Khartoum
    Africa/Kigali
    Africa/Kinshasa
    Africa/Lagos
    Africa/Libreville
    Africa/Lome
    Africa/Luanda
    Africa/Lubumbashi
    Africa/Lusaka
    Africa/Malabo
    Africa/Maputo
    Africa/Maseru
    Africa/Mbabane
    Africa/Mogadishu
    Africa/Monrovia
    Africa/Nairobi
    Africa/Ndjamena
    Africa/Niamey
    Africa/Nouakchott
    Africa/Ouagadougou
    Africa/Porto-Novo
    Africa/Sao_Tome
    Africa/Timbuktu
    Africa/Tripoli
    Africa/Tunis
    Africa/Windhoek
    America/Adak
    America/Anchorage
    America/Anguilla
    America/Antigua
    America/Araguaina
    America/Argentina/Buenos_Aires
    America/Argentina/Catamarca
    America/Argentina/ComodRivadavia
    America/Argentina/Cordoba
    America/Argentina/Jujuy
    America/Argentina/La_Rioja
    America/Argentina/Mendoza
    America/Argentina/Rio_Gallegos
    America/Argentina/Salta
    America/Argentina/San_Juan
    America/Argentina/San_Luis
    America/Argentina/Tucuman
    America/Argentina/Ushuaia
    America/Aruba
    America/Asuncion
    America/Atikokan
    America/Atka
    America/Bahia
    America/Bahia_Banderas
    America/Barbados
    America/Belem
    America/Belize
    America/Blanc-Sablon
    America/Boa_Vista
    America/Bogota
    America/Boise
    America/Buenos_Aires
    America/Cambridge_Bay
    America/Campo_Grande
    America/Cancun
    America/Caracas
    America/Catamarca
    America/Cayenne
    America/Cayman
    America/Chicago
    America/Chihuahua
    America/Ciudad_Juarez
    America/Coral_Harbour
    America/Cordoba
    America/Costa_Rica
    America/Creston
    America/Cuiaba
    America/Curacao
    America/Danmarkshavn
    America/Dawson
    America/Dawson_Creek
    America/Denver
    America/Detroit
    America/Dominica
    America/Edmonton
    America/Eirunepe
    America/El_Salvador
    America/Ensenada
    America/Fort_Nelson
    America/Fort_Wayne
    America/Fortaleza
    America/Glace_Bay
    America/Godthab
    America/Goose_Bay
    America/Grand_Turk
    America/Grenada
    America/Guadeloupe
    America/Guatemala
    America/Guayaquil
    America/Guyana
    America/Halifax
    America/Havana
    America/Hermosillo
    America/Indiana/Indianapolis
    America/Indiana/Knox
    America/Indiana/Marengo
    America/Indiana/Petersburg
    America/Indiana/Tell_City
    America/Indiana/Vevay
    America/Indiana/Vincennes
    America/Indiana/Winamac
    America/Indianapolis
    America/Inuvik
    America/Iqaluit
    America/Jamaica
    America/Jujuy
    America/Juneau
    America/Kentucky/Louisville
    America/Kentucky/Monticello
    America/Knox_IN
    America/Kralendijk
    America/La_Paz
    America/Lima
    America/Los_Angeles
    America/Louisville
    America/Lower_Princes
    America/Maceio
    America/Managua
    America/Manaus
    America/Marigot
    America/Martinique
    America/Matamoros
    America/Mazatlan
    America/Mendoza
    America/Menominee
    America/Merida
    America/Metlakatla
    America/Mexico_City
    America/Miquelon
    America/Moncton
    America/Monterrey
    America/Montevideo
    America/Montreal
    America/Montserrat
    America/Nassau
    America/New_York
    America/Nipigon
    America/Nome
    America/Noronha
    America/North_Dakota/Beulah
    America/North_Dakota/Center
    America/North_Dakota/New_Salem
    America/Nuuk
    America/Ojinaga
    America/Panama
    America/Pangnirtung
    America/Paramaribo
    America/Phoenix
    America/Port-au-Prince
    America/Port_of_Spain
    America/Porto_Acre
    America/Porto_Velho
    America/Puerto_Rico
    America/Punta_Arenas
    America/Rainy_River
    America/Rankin_Inlet
    America/Recife
    America/Regina
    America/Resolute
    America/Rio_Branco
    America/Rosario
    America/Santa_Isabel
    America/Santarem
    America/Santiago
    America/Santo_Domingo
    America/Sao_Paulo
    America/Scoresbysund
    America/Shiprock
    America/Sitka
    America/St_Barthelemy
    America/St_Johns
    America/St_Kitts
    America/St_Lucia
    America/St_Thomas
    America/St_Vincent
    America/Swift_Current
    America/Tegucigalpa
    America/Thule
    America/Thunder_Bay
    America/Tijuana
    America/Toronto
    America/Tortola
    America/Vancouver
    America/Virgin
    America/Whitehorse
    America/Winnipeg
    America/Yakutat
    America/Yellowknife
    Antarctica/Casey
    Antarctica/Davis
    Antarctica/DumontDUrville
    Antarctica/Macquarie
    Antarctica/Mawson
    Antarctica/McMurdo
    Antarctica/Palmer
    Antarctica/Rothera
    Antarctica/South_Pole
    Antarctica/Syowa
    Antarctica/Troll
    Antarctica/Vostok
    Arctic/Longyearbyen
    Asia/Aden
    Asia/Almaty
    Asia/Amman
    Asia/Anadyr
    Asia/Aqtau
    Asia/Aqtobe
    Asia/Ashgabat
    Asia/Ashkhabad
    Asia/Atyrau
    Asia/Baghdad
    Asia/Bahrain
    Asia/Baku
    Asia/Bangkok
    Asia/Barnaul
    Asia/Beirut
    Asia/Bishkek
    Asia/Brunei
    Asia/Calcutta
    Asia/Chita
    Asia/Choibalsan
    Asia/Chongqing
    Asia/Chungking
    Asia/Colombo
    Asia/Dacca
    Asia/Damascus
    Asia/Dhaka
    Asia/Dili
    Asia/Dubai
    Asia/Dushanbe
    Asia/Famagusta
    Asia/Gaza
    Asia/Harbin
    Asia/Hebron
    Asia/Ho_Chi_Minh
    Asia/Hong_Kong
    Asia/Hovd
    Asia/Irkutsk
    Asia/Istanbul
    Asia/Jakarta
    Asia/Jayapura
    Asia/Jerusalem
    Asia/Kabul
    Asia/Kamchatka
    Asia/Karachi
    Asia/Kashgar
    Asia/Kathmandu
    Asia/Katmandu
    Asia/Khandyga
    Asia/Kolkata
    Asia/Krasnoyarsk
    Asia/Kuala_Lumpur
    Asia/Kuching
    Asia/Kuwait
    Asia/Macao
    Asia/Macau
    Asia/Magadan
    Asia/Makassar
    Asia/Manila
    Asia/Muscat
    Asia/Nicosia
    Asia/Novokuznetsk
    Asia/Novosibirsk
    Asia/Omsk
    Asia/Oral
    Asia/Phnom_Penh
    Asia/Pontianak
    Asia/Pyongyang
    Asia/Qatar
    Asia/Qostanay
    Asia/Qyzylorda
    Asia/Rangoon
    Asia/Riyadh
    Asia/Saigon
    Asia/Sakhalin
    Asia/Samarkand
    Asia/Seoul
    Asia/Shanghai
    Asia/Singapore
    Asia/Srednekolymsk
    Asia/Taipei
    Asia/Tashkent
    Asia/Tbilisi
    Asia/Tehran
    Asia/Tel_Aviv
    Asia/Thimbu
    Asia/Thimphu
    Asia/Tokyo
    Asia/Tomsk
    Asia/Ujung_Pandang
    Asia/Ulaanbaatar
    Asia/Ulan_Bator
    Asia/Urumqi
    Asia/Ust-Nera
    Asia/Vientiane
    Asia/Vladivostok
    Asia/Yakutsk
    Asia/Yangon
    Asia/Yekaterinburg
    Asia/Yerevan
    Atlantic/Azores
    Atlantic/Bermuda
    Atlantic/Canary
    Atlantic/Cape_Verde
    Atlantic/Faeroe
    Atlantic/Faroe
    Atlantic/Jan_Mayen
    Atlantic/Madeira
    Atlantic/Reykjavik
    Atlantic/South_Georgia
    Atlantic/St_Helena
    Atlantic/Stanley
    Australia/ACT
    Australia/Adelaide
    Australia/Brisbane
    Australia/Broken_Hill
    Australia/Canberra
    Australia/Currie
    Australia/Darwin
    Australia/Eucla
    Australia/Hobart
    Australia/LHI
    Australia/Lindeman
    Australia/Lord_Howe
    Australia/Melbourne
    Australia/NSW
    Australia/North
    Australia/Perth
    Australia/Queensland
    Australia/South
    Australia/Sydney
    Australia/Tasmania
    Australia/Victoria
    Australia/West
    Australia/Yancowinna
    Brazil/Acre
    Brazil/DeNoronha
    Brazil/East
    Brazil/West
    CET
    CST6CDT
    Canada/Atlantic
    Canada/Central
    Canada/Eastern
    Canada/Mountain
    Canada/Newfoundland
    Canada/Pacific
    Canada/Saskatchewan
    Canada/Yukon
    Chile/Continental
    Chile/EasterIsland
    Cuba
    EET
    EST
    EST5EDT
    Egypt
    Eire
    Etc/GMT
    Etc/GMT+0
    Etc/GMT+1
    Etc/GMT+10
    Etc/GMT+11
    Etc/GMT+12
    Etc/GMT+2
    Etc/GMT+3
    Etc/GMT+4
    Etc/GMT+5
    Etc/GMT+6
    Etc/GMT+7
    Etc/GMT+8
    Etc/GMT+9
    Etc/GMT-0
    Etc/GMT-1
    Etc/GMT-10
    Etc/GMT-11
    Etc/GMT-12
    Etc/GMT-13
    Etc/GMT-14
    Etc/GMT-2
    Etc/GMT-3
    Etc/GMT-4
    Etc/GMT-5
    Etc/GMT-6
    Etc/GMT-7
    Etc/GMT-8
    Etc/GMT-9
    Etc/GMT0
    Etc/Greenwich
    Etc/UCT
    Etc/UTC
    Etc/Universal
    Etc/Zulu
    Europe/Amsterdam
    Europe/Andorra
    Europe/Astrakhan
    Europe/Athens
    Europe/Belfast
    Europe/Belgrade
    Europe/Berlin
    Europe/Bratislava
    Europe/Brussels
    Europe/Bucharest
    Europe/Budapest
    Europe/Busingen
    Europe/Chisinau
    Europe/Copenhagen
    Europe/Dublin
    Europe/Gibraltar
    Europe/Guernsey
    Europe/Helsinki
    Europe/Isle_of_Man
    Europe/Istanbul
    Europe/Jersey
    Europe/Kaliningrad
    Europe/Kiev
    Europe/Kirov
    Europe/Kyiv
    Europe/Lisbon
    Europe/Ljubljana
    Europe/London
    Europe/Luxembourg
    Europe/Madrid
    Europe/Malta
    Europe/Mariehamn
    Europe/Minsk
    Europe/Monaco
    Europe/Moscow
    Europe/Nicosia
    Europe/Oslo
    Europe/Paris
    Europe/Podgorica
    Europe/Prague
    Europe/Riga
    Europe/Rome
    Europe/Samara
    Europe/San_Marino
    Europe/Sarajevo
    Europe/Saratov
    Europe/Simferopol
    Europe/Skopje
    Europe/Sofia
    Europe/Stockholm
    Europe/Tallinn
    Europe/Tirane
    Europe/Tiraspol
    Europe/Ulyanovsk
    Europe/Uzhgorod
    Europe/Vaduz
    Europe/Vatican
    Europe/Vienna
    Europe/Vilnius
    Europe/Volgograd
    Europe/Warsaw
    Europe/Zagreb
    Europe/Zaporozhye
    Europe/Zurich
    GB
    GB-Eire
    GMT
    GMT+0
    GMT-0
    GMT0
    Greenwich
    HST
    Hongkong
    Iceland
    Indian/Antananarivo
    Indian/Chagos
    Indian/Christmas
    Indian/Cocos
    Indian/Comoro
    Indian/Kerguelen
    Indian/Mahe
    Indian/Maldives
    Indian/Mauritius
    Indian/Mayotte
    Indian/Reunion
    Iran
    Israel
    Jamaica
    Japan
    Kwajalein
    Libya
    MET
    MST
    MST7MDT
    Mexico/BajaNorte
    Mexico/BajaSur
    Mexico/General
    NZ
    NZ-CHAT
    Navajo
    PRC
    PST8PDT
    Pacific/Apia
    Pacific/Auckland
    Pacific/Bougainville
    Pacific/Chatham
    Pacific/Chuuk
    Pacific/Easter
    Pacific/Efate
    Pacific/Enderbury
    Pacific/Fakaofo
    Pacific/Fiji
    Pacific/Funafuti
    Pacific/Galapagos
    Pacific/Gambier
    Pacific/Guadalcanal
    Pacific/Guam
    Pacific/Honolulu
    Pacific/Johnston
    Pacific/Kanton
    Pacific/Kiritimati
    Pacific/Kosrae
    Pacific/Kwajalein
    Pacific/Majuro
    Pacific/Marquesas
    Pacific/Midway
    Pacific/Nauru
    Pacific/Niue
    Pacific/Norfolk
    Pacific/Noumea
    Pacific/Pago_Pago
    Pacific/Palau
    Pacific/Pitcairn
    Pacific/Pohnpei
    Pacific/Ponape
    Pacific/Port_Moresby
    Pacific/Rarotonga
    Pacific/Saipan
    Pacific/Samoa
    Pacific/Tahiti
    Pacific/Tarawa
    Pacific/Tongatapu
    Pacific/Truk
    Pacific/Wake
    Pacific/Wallis
    Pacific/Yap
    Poland
    Portugal
    ROC
    ROK
    Singapore
    Turkey
    UCT
    US/Alaska
    US/Aleutian
    US/Arizona
    US/Central
    US/East-Indiana
    US/Eastern
    US/Hawaii
    US/Indiana-Starke
    US/Michigan
    US/Mountain
    US/Pacific
    US/Samoa
    UTC
    Universal
    W-SU
    WET
    Zulu