Javascript – Regex to split string along &
I have this string PENNER,JANET E TR-50% & PENNER,MICHAEL G TR - 50% & SOURCE LLC & LARRY & FREDDY INC and I want to split it up into groups like this PENNER,JANET E TR PENNER,MICHAEL G TR SOURCE LLC…
Postgresql – Adding a comma to strings that matches a regular expression pattern, but a few characters away
I am trying to add a comma and a space to my strings. Here are some examples: {ELEPHANT:1, FENNEC_FOX:1NAKED_MOLE:1URCHIN:2} {DUNG_BEETLE:12URCHIN:1} {DUNG_BEETLE:1FENNEC_FOX:1URCHIN:2} Notice the inconsistent lack of ", ". I would like to outcome to be {ELEPHANT:1, FENNEC_FOX:1, NAKED_MOLE:1, URCHIN:2} {DUNG_BEETLE:1,…
MySQL complex REGEXP find and replace
I want to run a regexp find and replace on a wordpress database, specifically the in wp_posts table, in the post_content column. I have several affiliate URLs scattered in the text of the post_content column, and I need to replace…
Php – Regex to exclude some symbols from a class but extending with others not included
I am trying to write a RegEx to generate random strings of the type [:graph:] but exclude some specific characters contained in the string $blacklist (for example some symbols may be absent on specific language keyboards and not necessarily everyone…
Javascript – how to split a continues hex string into space delimited hex blocks of 32 tuplets each?
I have a fairly long hex string Buffer.toString("hex") that I want to print to a log file in a block of 32 tuplets each. So basically going from e01102020809020300800202020809020208095f520c8066054445472b44739621e0d003040401d21044454946583532463447444a4d010000d3104445472b445333374f53474b32010000d4104445472b44533337474b563033010000d503040401d6104445472b444342324354473031010000d7104445472b44504450535f5f5f5f0106009000 to e0 11 02 02 08 09 02 03 00 80…
Postgresql – How to remove duplicates and inc table records using postgres sql regex
I have created scenario in fiddle where I have to remove duplicate records and keep only 1 record example : for spotted table mfg_lz.icc_axbi_kanban_job there are 2 records so need to remove duplicate and keep only 1. select field1 ,unnest(…
Ubuntu – Need help forming several Lighttpd conditional redirects for PHP router
I am trying to set up a few conditional redirects for a lighttpd installation on Ubuntu. I would like the following: https://www.example.com/clients/xyz https://www.example.com/admin/xyz To pass through normally, but something like: https://www.example.com/abc123 To redirect to the "index.php" page at the web…
Javascript – unable to understand logic difference between regex
What's the difference between /^(?=.*[w])$/ and /^(?=.*[w]). /^(?=.*[w])$/.test('a') return false /^(?=.*[w])/.test('a') return true. Why is that?
Javascript – Regex Comparison not working as expected
const columnDateIndex = [ { path: "2023|Jan 2023" }, { path: "2023|Feb 2023" }, { path: "2023|Mar 2023" }, { path: "2023|Apr 2023" }, { path: "2023|May 2023" }, { path: "2023|Jun 2023" }, { path: "2023|Jul 2023" }, {…
PHP perl regular expression – URL not preceded by equal sign and possible single or double quote
I'm trying to create a perl regular expression that matches a URL that is not preceded by an equal sign and one single or double quote (optional) ignoring whitespace. The code below gives an error: Warning: preg_replace(): Compilation failed: lookbehind…