Tabula Documentation
Tabula HomeCommunity
  • 👋Introduction to Tabula
  • Getting Started
    • Product Updates
    • Getting Started
      • Installation and Login
      • Beginner's Guide
    • FAQ
  • Product overview
    • Home Page
    • Exploring Data
      • Data Catalog
      • Exploring Datasets
      • Statistics Panel
    • Designing Flows
      • Creating Flows
      • Flow Designer Guide
        • Working with Canvas
        • Using Groups
        • Working with Table
      • Managing Flows
      • Sharing Flows
      • Demo: Building a Simple Flow
    • Executing Flows
      • Running Flows
      • Jobs overview
    • Building Reports
      • Designing Reports
      • Running Reports
      • Reports Page
    • Connecting Data
  • Integrations
    • Enrichments
      • How to add your API key in Tabula
      • List of Supported Queries
      • Enrichment Providers
        • AnymailFinder
        • Apollo
          • How to find Apollo API key
          • Enrich person by LinkedIn
          • Enrich company by domain
        • Bounceban
        • Bouncer
        • Bouncify
        • CaptainVerify
        • Cleanify
        • Clearout
        • CompanyEnrich
        • ContactOut
          • How to find ContactOut API key
          • Enrich person by LinkedIn
          • Enrich person by email
        • Discolike
        • TheCompaniesAPI
        • Findymail
        • Emailable
        • EmailListVerify
        • Enrichley
        • Heybounce
        • Hunter
        • Kickbox
        • Mails
        • MailChecker
        • MillionVerifier
        • NeverBounce
        • Nubela (Proxycurl)
        • PeopleDataLabs
        • Prospeo
        • ZeroBounce
        • ReverseContact
          • How to find Reverse Contact API key
          • Enrich person by LinkedIn
          • Enrich person and company by email
          • Enrich company by domain
          • Enrich company by LinkedIn
        • UpLead
    • Data Sources
      • Configuring Fivetran Integration
    • Data Storages
      • PostgreSQL
      • Snowflake
      • BigQuery
      • ClickHouse
  • Data Transformation
    • Transforms
      • Source
      • New Empty Table
      • Output
      • Chart
      • Enrichment
      • New Column
      • If...Then
      • Rolling Functions
      • Column Type
      • Columns Edit
      • Filter
      • Remove Duplicates
      • Sort
      • Find and Replace Text
      • Split Column
      • Extract Text
      • Match Text
      • Join
      • Union
      • Group By
      • Pivot
      • Unpivot
      • To JSON
      • From JSON
      • API Call
      • AI Column
      • AI Table
    • Formulas
      • What are Formulas?
      • Math Functions
        • Abs
        • Ceiling
        • Exp
        • Floor
        • IsEven
        • IsOdd
        • Ln
        • Log
        • Log10
        • Mod
        • Pi
        • Power
        • Quotient
        • Round
        • RoundDown
        • RoundUp
        • Sign
        • Sqrt
        • Truncate
      • Trigonometric Functions
        • Acos
        • Asin
        • Atan
        • Atan2
        • Cos
        • Cot
        • Degrees
        • Radians
        • Sin
        • Tan
      • String Functions
        • Compare
        • Concat
        • Contains
        • In
        • CountMatches
        • CountMatchesRegexp
        • EndsWith
        • EndsWithRegexp
        • Extract
        • FindMatchOfString
        • FindMatchOfRegexp
        • FindMatchesOfString
        • FindMatchesOfRegexp
        • Left
        • Length
        • Lower
        • Matches
        • Pad
        • ProperCase
        • RemoveSymbols
        • RemoveWhitespaces
        • Repeat
        • Replace
        • ReplaceRegexp
        • Reverse
        • Right
        • Spaces
        • Split
        • SplitRegexp
        • StartsWith
        • StartsWithRegexp
        • Stuff
        • Substring
        • SubstringDelimiter
        • SubstringRegexpDelimiter
        • Trim
        • Upper
      • Date & Time Functions
        • Date
        • DateAdd
        • DateAdd2
        • DateDiff
        • DateDiff2
        • DateFromParts
        • DateTime
        • DateTimeFromParts
        • DateTrunc
        • DayName
        • DayOfMonth
        • DayOfWeek
        • DayOfYear
        • Hour
        • Minute
        • Month
        • MonthName
        • Now
        • Quarter
        • Second
        • Time
        • TimeFromParts
        • Today
        • Week
        • Year
      • Aggregate Functions
        • Any
        • AnyIf
        • Array
        • ArrayIf
        • Avg
        • AvgIf
        • AvgInRow
        • Count
        • CountA
        • CountIf
        • CountUnique
        • Max
        • MaxIf
        • MaxInRow
        • Median
        • MedianIf
        • Min
        • MinIf
        • MinInRow
        • Mode
        • ModeIf
        • Percentile
        • Quartile
        • StdDev
        • StdDevIf
        • Sum
        • SumIf
        • SumProduct
        • Variance
        • VarianceIf
      • Conversion Functions
        • ToArray
        • ArrayToString
        • ToBoolean
        • ToDate
        • ToDateTime
        • ToDecimal
        • ToInteger
        • ToObject
        • ToTime
        • ToString
      • Misc Functions
        • At
        • IsMissing
        • RowNumber
        • Random
        • If
        • Coalesce
        • True
        • False
        • Null
        • $target
      • Window Functions
      • Custom Functions
      • Data Types
      • Supported Date Parts
      • Regex: List of Tokes
  • Pricing & Billing
    • Plans, Subscriptions, and Credits
    • Tabula for Education
  • Tutorials
    • Tabula Use Cases
    • Merge Columns
    • Join Types
    • Union Introduction
    • Window Functions
    • What is Unpivot?
    • JSON Format Tutorial
    • Using Regex
Powered by GitBook
  1. Data Transformation
  2. Formulas

Regex: List of Tokes

Description
Extended description
Example

A single character of: a, b or c

Matches either an a, b or c character

[abc]

A character except for: a, b or c

Matches any character except for an a, b or c

[^abc]

A character in the range: a-z

Matches any characters between a and z, including a and z.

[a-z]

A character not in the range: a-z

Matches any characters except those in the range a-z.

[^a-z]

A character in the range: a-z or A-Z

Matches any characters between a-z or A-Z. You can combine as much as you, please.

[a-zA-Z]

Any single character

Matches any character other than newline (or including line terminators with the /s flag)

.

Alternate - match either a or b

Matches either what is before the | or what is after it - in this case `a` or `b`.

a|b

Any whitespace character

Matches any space, tab or newline character.

\s

Any non-whitespace character

Matches anything other than a space, tab or newline.

\S

Any digit

Matches any decimal digit. Equivalent to [0-9].

\d

Any non-digit

Matches anything other than a decimal/digit.

\D

Any word character

Matches any letter, digit or underscore. Equivalent to [a-zA-Z0-9_].

\w

Any non-word character

Matches anything other than a letter, digit or underscore. Equivalent to [^a-zA-Z0-9_]

\W

Match everything enclosed

A non-capturing group allows you to apply quantifiers to part of your regex but does not capture/assign an ID.

(?:...)

Capture everything enclosed

Isolates part of the full match to be later referred to by ID within the regex or the matches array. IDs start at 1.

(...)

Zero or one of a

Matches an `a` character or nothing.

a?

Zero or more of a

Matches zero or more consecutive `a` characters.

a*

One or more of a

Matches one or more consecutive `a` characters.

a+

Exactly 3 of a

Matches exactly 3 consecutive `a` characters.

a{3}

3 or more of a

Matches at least 3 consecutive `a` characters.

a{3,}

Between 3 and 6 of a

Matches between 3 and 6 (inclusive) consecutive `a` characters.

a{3,6}

Start of string

Matches the start of a string without consuming any characters. If /m multiline mode is used, this will also match immediately after a newline character.

^

End of string

Matches the end of a string without consuming any characters. If multiline mode is used, this will also match immediately before a newline character.

$

A word boundary

Matches, without consuming any characters, immediately between a character matched by \w and a character not matched by \w (in either order). It cannot be used to separate non words from words.

\b

Non-word boundary

Matches, without consuming any characters, at the position between two characters matched by \w.

\B

Newline

Matches a newline character

\n

Carriage return

Matches a carriage return, unicode character U+2185.

\r

Tab

Matches a tab character. Historically, tab stops happen every 8 characters.

\t

Null character

Matches a null character, most often visually represented in Unicode using U+2400.

\0

Positive Lookahead

Asserts that the given subpattern can be matched here, without consuming characters

(?=...)

Negative Lookahead

Starting at the current position in the expression, ensures that the given pattern will not match. Does not consume characters.

(?!...)

Positive Lookbehind

Ensures that the given pattern will match, ending at the current position in the expression. The pattern must have a fixed width. Does not consume any characters.

(?<=...)

Negative Lookbehind

Ensures that the given pattern would not match and end at the current position in the expression. The pattern must have a fixed width. Does not consume characters.

(?<!...)

PreviousSupported Date PartsNextPlans, Subscriptions, and Credits

Last updated 1 year ago

Was this helpful?