Skip to content Skip to sidebar Skip to footer
Showing posts with the label Regex

Sql/regex Challenge/puzzle: How To Remove Comments From Sql Code (by Using Sql Query)?

Requirements Single-lines comments (e.g. -- my comment) should be removed. Multi-line comments (e.… Read more Sql/regex Challenge/puzzle: How To Remove Comments From Sql Code (by Using Sql Query)?

How Do I Extract Selected Columns Given An Oracle Sql String?

OK, this might seem too tough to be posted here so I beg your pardon. Been working on this for almo… Read more How Do I Extract Selected Columns Given An Oracle Sql String?

Oracle Get All Matched Occurrences From A Column

I have a table, which has 2 columns: ID & JOB_Description(Text). I would like to write an oracl… Read more Oracle Get All Matched Occurrences From A Column

Extract Email Address From String Using Tsql

I'm trying to extract email addresses from an existing comments field and put it into its own c… Read more Extract Email Address From String Using Tsql

Bigquery - Regex To Match Number Of 8 Digits After A Known String

I need to extract 8 digits after a known string: | MyString | Extract: | | ---… Read more Bigquery - Regex To Match Number Of 8 Digits After A Known String

Why Won't This Regex Work In Postgresql

I'm trying to get a regex to capture the base URL from a URL string. This ^(.+?[^\/:])(?=[?\/]|… Read more Why Won't This Regex Work In Postgresql