I have a field in a PostgreSQL table, name, with this format: JOHN^DOE BILLY^SMITH FIRL^GREGOIRE NOEL^JOHN and so on. The format is LASTNAME^FIRSTNAME. The table has ID, name, birthdate and sex …
Tag: regex
SQL: Remove part of string that is in another column of the table using REGEXP_REPLACE
I have a column that looks like so, but with more rows: Now, I am trying to remove the cat name from the message on each row in the table, so that I can see what the messages sent to each cat are, and which cats got the same message (i.e. this way I would be able to see that
How to format in PostgreSQL CITEXT variable to a regex to be used for search
First of all – all credits goes to Laurenz Albe answer here I hava a JSONB colum where I need to perform a search on the values (exactly as explained in the linked question). I think to get advantage …
Extract first argue from column with T-SQL
I need to extract the first argument: “PATHTOPACKAGE” from the string below: which is a column stored at SQL Server msdb.sysjobsteps.command Is there a way to do it by using Regex or Spliting it by blank spaces? Answer Based on the one example we have, a couple of CHARINDEXs a little bit of simple…
presto replace multiple characters
I have a string and would like to remove a set of characters. Is there a better way than chaining multiple replace()? I came up with the following but it requires a replace() call for each character: This is a minimal example and I have more characters to escape so I was looking for a less verbose way of achi…
MySql regexp on column with html
I have a table with HTML content in which I need to select all rows containing a span element with the CSS class “glyphicon glyphicon-film” with some text content, but exclude all rows …
How to count non-zero numbers in a comma separated string in oracle sql
Want to count non-zero numbers from a comma separated string in oracle 12.10. If my column has data as 2000,300,0,0 then count it as 2. This gives me 2000 and 300 as result but what’s next to count it. select regexp_substr(‘2000,300,0,0′,'[^,]+’,1,level) from dual connect BY to_number(…
tweetImage not showing an image
Here is my line 51, Here is my code. When I execute it I GET THIS When i replace ‘tweetImage’ with ‘profileImage’in line 51.My profileImage successfully gets uploaded in place of blank thumbnail.I want the tweetImage uploaded by the user to be uploaded in place of the blank thumbnail.I…
REGEX Extract Amount Without Currency
SELECT ocr_text, bucket, REGEXP_EXTRACT(‘-?[0-9]+(.[0-9]+)?’, ocr_text) FROM temp I am trying to extract amounts from a string that will not have currency present. Any number that does …
Match specific string before user input
I have the following strings: SDZ420-1241242, AS42-9639263, SPF3-2352353 I want to “escape” the SDZ420- part while searching and only search using the last digits, so far I’ve tried RLIKE …