Results of 1 - 6 of about 6 for regex (0.003 sec.)
- Text Functions – DuckDB 12448
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...epted. string LIKE target Returns true if the string matches the like specifier (see Pattern Matching ). string SIMILAR TO regex Returns true if the string matches the regex (see Pattern Matching ). string ^@ search_string Returns true if string begin...file with invalid UTF-8 an error is thrown suggesting to use read_blob instead. See the read_text guide for more details. regexp_escape(string) Escapes special patterns to turn string into a regular expression similarly to Python's re.escape function.... regexp_extract(string, regex[, group][, options]) If string contains the regex pattern, returns the capturing group specified by... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Regular Expressions – DuckDB 10638
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...regular expression syntax, see the RE2 docs . Functions All functions accept an optional set of options . Name Description regexp_extract(string, pattern[, group = 0][, options]) If string contains the regexp pattern , returns the capturing group spec...string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set. regexp_extract(string, pattern, name_list[, options]) If string contains the regexp pattern , returns the capturing groups as a...ruct with corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. regexp_extract_all(string, regex[, group = 0][, options]) Finds non-overlapping occurrences of regex in string and returns the c... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Result Verification – DuckDB 8737
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...es is changed. statement error SELECT * FROM non_existent_table ; ---- Table with name non_existent_table does not exist ! Regex In certain cases result values might be very large or complex, and we might only be interested in whether or not the resul...t contains a snippet of text. In that case, we can use the <REGEX>: modifier followed by a certain regex. If the result value matches the regex the test is passed. This is primarily used f...SELECT tbl.a FROM 'data/parquet-testing/arrow/alltypes_plain.parquet' tbl ( a ) WHERE a = 1 OR a = 2 ---- physical_plan < REGEX > :. * PARQUET_SCAN . * Filters : a = 1 OR a = 2 . * If we instead want the result not to contain a snippet of text, we ca... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- PostgreSQL Compatibility – DuckDB 7768
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...L does not do this. For an example, run: SELECT ARRAY [ ' '' ' ]; PostgreSQL returns: {'} DuckDB returns: ['\''] Functions regexp_extract Function Unlike PostgreSQL's regexp_substr function, DuckDB's regexp_extract returns empty strings instead of NUL...r Expression Match Operators PostgreSQL supports the POSIX regular expression matching operators ~ (case-sensitive partial regex matching) and ~* (case-insensitive partial regex matching) as well as their negated variants, !~ and !~* , respectively. I...n DuckDB, ~ is equivalent to regexp_full_match and !~ is equivalent to NOT regexp_full_match . The operators ~* and !~* are not supported. The table below sh... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Benchmark Suite – DuckDB 7622
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ression You can also use a regular expression to specify which benchmarks to run. Be careful of shell expansion of certain regex characters (e.g., * will likely be expanded by your shell, hence this requires proper quoting or escaping). build/release/... - https://man.mtool.work/duckdb/1.3/dev/benchmark.html
- Analyzing a Git Repository – DuckDB 7549
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...estion: which topic was the most commonly mentioned in the commit messages: CI, CLI, or Python? SELECT message. lower () . regexp_extract ( '\b(ci|cli|python)\b' ) AS topic , count ( * ) AS num_commits FROM commits WHERE topic <> '' GROUP BY ALL ORDER...the commit messages. To do so, we first tokenize the messages: CREATE TABLE words AS SELECT unnest ( message . lower () . regexp_replace ( '\W' , ' ' ) . trim ( ' ' ) . string_split_regex ( '\W' ) ) AS word FROM commits ; Then, we remove stopwords us... - https://man.mtool.work/duckdb/1.3/guides/snippets/analyze_git_repository.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work