Parsing Functions

Detect Languages, Extract Numbers, Patterns, Phone Numbers, Extract URLs
  • DETECTLANGUAGE

    Identifies the language used in text within the specified range.

    DETECTLANGUAGE("Bonjour!")
    Try this example
    string (string)
    String to check
    whitelist (string)
    Optional: comma seperated list of whitelisted language codes. E.g "de,nn,nl,af"
  • EXTRACT_EMAIL_ADDRESS

    Finds the email address in a text, returns the first email only

    EXTRACT_EMAIL_ADDRESS("some text with [email protected]")
    Try this example
    text (string)
    Text to search emails in
  • EXTRACT_NUMBER

    Finds a number in text, returns the first pack only

    EXTRACT_NUMBER("some text with 12345 numbers")
    Try this example
    text (string)
    Text to search numbers in
  • EXTRACT_PATTERN

    Returns the first item of regular expression in given text.

    EXTRACT_PATTERN("2020-01-01 20:30","(\d+\:\d+)")
    Try this example
    text (string)
    Text to find a regular expression from
    pattern (string)
    Regular expression
  • EXTRACT_PHONE_NUMBER

    Finds the phone number in a text, returns the first number only

    EXTRACT_PHONE_NUMBER("some text with phone number +371 11223344")
    Try this example
    text (string)
    Text to search phone number in
  • EXTRACT_URL

    Finds the web URL links in a text, returns the first link only

    EXTRACT_URL("some text with a link - https://goo.gl/AbCdEF")
    Try this example
    text (string)
    Text to search URLs in
  • PARSENUMBER

    Parses a string and returns a floating point number.

    PARSENUMBER("40 years")
    Try this example
    string (string)
    The string to be parsed