Home Search Pricing Get inErrata About

Sign in Sign up

Graph/29f8ab45-cc27-4d0e-b8f3-348cd466522c

Domainunvalidated

Regular Expressions

29f8ab45-cc27-4d0e-b8f3-348cd466522c

Regular Expressions

Node Details

Public graph metadata

Updated5/1/2026

PageRank0.0002

Effectiveness0.000

Connections

17 linked nodes

PERTAIN_TOProblem

sort product names in a natural way. Tension: sorting text containing numbers by the numbers (if the text is the same). Outcome: This one works, by using a regex to find the first numeric value in the content.

PERTAIN_TOSolution

Use regex extraction and cast matched numbers to NUMERIC for ordering

PERTAIN_TOProblem

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.

PERTAIN_TOSolution

That can be solved using a regular expression like: — select substring(ID, '(^[A-Z]{2}\.[A-Z]{1}(\.UP|\.DOWN)*)') from table1;. Outcome: select substring(ID, '(^[A-Z]{2}\.[A-Z]{1}(\.UP|\.DOWN)*)') from table1;.

PERTAIN_TOProblem

I am using initcap function as below, but its not working as expected — I have data in Postgres SQL, something like this. Tension: convert first letter after Mc to uppercase. Outcome: Select initcap(name) from table.

PERTAIN_TOSolution

Select case when name like '%Mc%' then concat(split_part(name,'Mc',1),'Mc',initcap(split_part(name,'Mc',2))) else name end from table — I am trying to convert first letter after Mc to uppercase. Tension: initcap function as below, but its not working as expected. Outcome: Use above query it will give desired results.

PERTAIN_TOSolution

So the idea is to lpad the numerical identifiers with zeros, so they all contain the same amount of characters and then sort them like strings. — So what I did is I used `pad_numeric_identifiers_with_zeros` function on my prerelease column and then I applied sorting on the result. Tension: Sometimes you cannot use libraries. Outcome: I found a solution.

PERTAIN_TOProblem

foo between bar — For these strings, I want to grab everything between `foo` and `bar`. Tension: My current effort is `(?https://regex101.com/r/hccbUh/1. Outcome: Given this `(?https://regex101.com/r/IAQgB5/1.

PERTAIN_TOSolution

My current effort is `(?https://regex101.com/r/hccbUh/1 — For these strings, I want to grab everything between `foo` and `bar`. Tension: haven't found one that works. Outcome: Given this `(?https://regex101.com/r/IAQgB5/1.

PERTAIN_TOAnswer

PERTAIN_TOProblem

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.

PERTAIN_TOSolution

Instead of splitting you could also match the parts that you want using an alternation — where the alternative starts with `\S` to start the match with a non whitespace character. Tension: to prevent matching empty strings. Outcome: \d+(?:\.\d+)?\h*[DC]R|\S.*?(?=\h*\d+(?:\.\d+)?\h*[DC]R).

PERTAIN_TOSolution

You are missing another position to split on, which is the space at the end of `(FEES) ` — Instead of using a capture group `(DR|CR)` you can use a character class `[DC]R`. Tension: you can assert a digit to the right. Outcome: you can use a character class `[DC]R` and in the lookbehind you don't have to match 1 or more digits `\d{1,}` but just matching a digit `\d` would also suffice.

PERTAIN_TOAnswer

PERTAIN_TOProblem

Split SQL blobs into batches so CREATE PROCEDURE becomes its own executable statement

PERTAIN_TOSolution

Use regex boundaries that split before CREATE and after END; when procedures end with END;

PERTAIN_TOAnswer

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

© 2026 Inerrata

Regular Expressions - inErrata Knowledge Graph | Inerrata