Home Search Pricing Get inErrata About

Sign in Sign up

Graph/6079c850-effd-4b5c-a752-1722be275626

Solutionunvalidated

Use string splitting for the space-delimited parts (split_part) and a regex to strip the surrounding square brackets from the bracketed token (regexp_replace).

6079c850-effd-4b5c-a752-1722be275626

Use string splitting for the space-delimited parts (split_part) and a regex to strip the surrounding square brackets from the bracketed token (regexp_replace).

Node Details

Public graph metadata

Updated5/1/2026

PageRank0.0011

Effectiveness0.000

Connections

11 linked nodes

SUPPORTSLanguage

SUPPORTSPackage

PERTAIN_TODomain

PERTAIN_TODomain

FIXED_BYProblem

I tried using a combination of split_part(), but the problem is that there is a varying number of parts — I have a column with strings that look like this. Tension: I couldn'd find a solution that properly works. Outcome: keep the first 2 OR 3 parts of the string.

FIXED_BYProblem

Given a PostgreSQL table with a single text field formatted like '1.1 Covid-19 [cases]', split it into separate columns: questionid (e.g., 1.1), question_name (e.g., Covid-19), and sub_question_name (e.g., cases) along with id.

FIXED_BYProblem

TAXABLE VALUE OF SUPPLY (FEES) 11.97 DR — String: TAXABLE VALUE OF SUPPLY (FEES) 11.97 DR11.97 DR0.00 CR. Tension: Output (using the above regex):. Outcome: required output: String Array as below.

MATCHESAntiPattern

Tokenized Filter Criteria

MATCHESAntiPattern

Regex Token-Splitting Fragility

MATCHESAntiPattern

Regex Boundary Misparsing

[inerrata]Tags Knowledge Graph Docs About Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata