Tabulify - Glob Pattern

Tabulify - Glob Pattern

Glob Pattern

Glob pattern are used in Tabulify to select objects such as :

If you are new to glob pattern, see this page Tabulify - How to select data resources with a Glob Pattern

Wildcard support

The following wildcard are supported in order to define the glob pattern:

  • * that matches every characters
  • ** matches all container (directories/schema). Use for recursive search (for instance **/foo.md will search all foo.md files in all sub directories)
  • ? that matches a single character
  • [] that matches a class of character (Example: [0-9] matches all digit)
  • [!] that does not match a character in the class of character. (Example: [!0-9] will not match a digit)
  • {pattern1,pattern2,..} to match a collection of sub-pattern (Example: {temp*,tmp*} matches all data resource name that begins with temp or tmp). It creates also a group for back-referencing.

Back-referencing

When data resources are selected via globbing, they get extra numeric variables that captures the text that matches.

ie:

  • the variable 1 is the text captured by the first glob pattern
  • the variable 2 is the text captured by the second glob pattern
  • and so on.

You can use this extra variable in:

Example with the data list command that:

  • selects the table that starts with web on a tpcds schema
  • shows the 1 first back-reference value
tabul data list -a 1 web_*@tpcds
path          media_type     1
-----------   ------------   -------
web_page      sql/relation   page
web_returns   sql/relation   returns
web_sales     sql/relation   sales
web_site      sql/relation   site




Related HowTo
Undraw Text Files
How to install the World MySQL Sample Schema

This howto will show you how to install the world sample schema of MySQL. The installation is done with the sql script world.sql This script is idempotent...
Undraw Text Files
Learning Tabulify - Step 4 - How to select Data Resources

To select a data resources such as a file or a database table, Tabulify uses the concept of: and dependency (Do we select also the dependent data resources) This page goes through this concepts...
Undraw Text Files
Learning Tabulify - Step 9 - How to fill a data resource with generated data ?

Tabulify integrates natively a data generator. You can generate realistic production data and start working on your project right away. anonymize production data in your development environment because...
Undraw Text Files
Tabul - How to list connections

This How-To shows you how to list connections with the tabul connection list command
Undraw Text Files
Tabulify - How to fill a database relational schema with generated data and Tabul

This how-to will show you how to use the tabul fill command to fill all the tables of a schema with generated data.
Undraw Text Files
Tabulify - How to select data resources with a Glob Pattern

With this howto, you will learn what a glob pattern is and how to use it to select data resources.

Task Runner