Tag: regex

Group by portion of field

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 …

SQL: Remove part of string that is in another column of the table using REGEXP_REPLACE

google-bigquery regex sql

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

postgresql regex sql string where-clause

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

regex split sql sql-server sql-server-2012

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 string manipulation gets the job done:

presto replace multiple characters

presto regex replace sql string

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 achieving

MySql regexp on column with html

mysql regex sql

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

count oracle regex sql string

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(regexp_substr(‘2000,300,0,0’, ‘[^,]+’,1,level)) > 0 Thanks for helping me. I know I am missing a basic

tweetImage not showing an image

mysql php regex sql

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 can’t seem to figure out much as i am one week

REGEX Extract Amount Without Currency

presto regex sql

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

mysql mysql-regexp regex sql

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 …