I’m getting the characters ‘?*’ one to three times in a column called Line. I am required to remove these characters. How do I do it using Replace or REGEXP_REPLACE? SELECT Line, REGEXP_REPLACE(…
Tag: regex
Use of Regex in SQL query
create table numbers (number varchar(10)); insert into numbers (number) values (‘9999999999’), (‘5532003644’), (‘1212121205’), (‘1103220311’), …
how remove special character and digits from a string but ignore white spaces
i tried to remove special characters and numeric number from string of sentence but it should ignore white spaces if there is a more than one it should replace with one SQL developer,oracle 11g …
oracle: remove only blank lines
How to remove empty lines in sql or plsql Input select ‘test1 test2 test3 test4’ from dual; Expected output: test1 test2 test3 test4 TRANSLATE is removing all the new line character
Split CLOB column based on new line – Oracle SQL
I have a table table1 f_name f_content test1.txt YL*1**50*1~ RX*1~ LR*2~ test2.txt YL*1**49*1~ EE*1~ WW*2~ f_content is CLOB f_name is varchar2 (…
Split a string into two fields based on multiple words
I have the following column in my Table name:STAT It would be helpful if someone can assist in writing a mysql script I would like to split the strings in to 2 columns. However the split should happen only based on the last word, i.e the Region as can be seen in the example below. There is an exception that
Selecting string after the last \ using regex with Impala SQL
I have a dataset with a column with processes and the path. I am trying to use regex with Impala to strip off the executable. The dataset looks like this: C:\Windows\System32\svchost.exe C:\…
SQL similar to regex, equivalents for start ^ and end $ of line
I want to use a regex like (^|s)1001(s|$) in a Firebird similar to expression: Examples: abc 1001 abc – true abc 121001 abc – false 1001 abc – true 121001 – false abc 1001 – true I try’d to convert it to a regex in Firebird: Where COLUMN similar to (^|[:WHITESPACE:])abc 100…
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 oracle SQL to extract all substrings in the Description column which match a regular pattern. However, I have learnt how to extract matched substrings from a string with below SQL, but I have no idea to apply below S…
mysql statmet that match exaxct “1” using regex
I want to create a regex to find a single 1 from the flowing the following list is the sample of the column value I like to search in 1,2 2,1 3,1,2 7,171,818 71,17,11 1 Note: the needed match is bolded in the prev list Answer You can go with either approach …