Advertisements I have a string of comma separated values, that I want to trim down for display purpose. The string is a comma separated list of values of varying lengths and number of list entries. Each entry in the list is formatted as a five character pattern in the format "##-NX" followed by some text.… Read More Regular expression to remove a portion of text from each entry in commas separated list
Advertisements my_Query – SELECT (regexp_matches(‘datavalue=Document{{value=[5]}}’, ‘datavalue=Document{{value=([^d}},”]+)’))[1] response; current output is square bracket – [5] I require without square bracket – 5 >Solution : To extract a part of a string based on a regex, substring() is the better alternative: substring(‘datavalue=Document{{value=[5]}}’ from ‘datavalue=Document{{value=\[([0-9]+)\]}}’) response;
Advertisements I want to replace all occurrences of case 1: a single space between 2 letters case 2: a single space between a closing brace } and a letter with \times such that ‘a^{3} + 3 a^{2} b + 3 a b^{2} + b^{3}’ becomes ‘a^{3} + 3 \\times a^{2} \\times b + 3 \\times… Read More What is the regex to replace a single space between a closing brace and a letter?
Advertisements I’m working with html templates that have variables inside. These variables are going to be replaced with some values (by regular expression). But some variables I want to exclude. Here is my test html code: data-coupon-patern="test {{SALE}} test" test {{SALE}} test " test {{SALE}} test data-coupon-patern="test {{SALE}} test" data-text="test {{SALE}} test My goal is… Read More Ignore specific value inside html attribute by Regexp
Advertisements Let’s say I have a sequence of numbers for example: 28937705095, 61926197003 or even 721.095.260-84. I would like to mask the first three numeric digits and the last two numeric digits, to something like this: 28937705095 => XXX377050XX 61926197003 => XXX261970XX 721.095.260-84 => XXX.095.260-XX I was using javascript for this and I believe that… Read More Regex look ahead to replace numbers
Advertisements I have a bunch a chars that I want to detect to change it for their equivalents in a query in postgres. For example, If I have this string ‘Résidence du Château de Salles’ I want to change the char ‘é’ by the char ‘e’ and the char ‘â’ by the char ‘a’. The… Read More Postgres: How to replace chars with different patterns?
Advertisements can i get only the substitution of the Regex.Replace? Example. String text = @"asdfgs sda gsa ga s SECTOR:124 NAME:Ricko asdfgs sda gsa ga s"; String regex = "^SECTOR:(\d+) NAME:(\w+)"; String substitution = "$2 $1"; String result = Regex.Replace(text, regex, substitution); Console.WriteLine(result); Normal result asdfgs sda gsa ga s Ricko 124 Wanted result Ricko… Read More Retrive only replacement template of regex in C#
Advertisements Let me start by saying that i am new to python. line = "lmn = abc(xyz)/123/…/abc(123)" line = "abc(xyz) = dlf/hmn/abc(fdg)" The pattern replacement example I am trying is abc(xxx) = $xxx something along these lines. The regex I have created is (abc\()(.*?)(\)) –> this is working fine. Now how do I ensure the… Read More Problem to replace all strings in a line which have a specific pattern in python
Advertisements I want to format the strings in a table column, in a specific format. Input Table: file_paths my-file-path/wefw/wefw/wef/wfweof=wefonwe/wfewoi=weoif/ my-file-path/wefw/wef/ef=wefonwe/wfewoi=weoif/ my-file-path/wef/wfe/wefw/wef/ef=wefonwe/wfewoi=weoif/ I want to remove everything after the first = sign, then remove everything before the = sign and after the last / sign. Output: file_paths my-file-path/wefw/wefw/wef/ my-file-path/wefw/wef/ my-file-path/wef/wfe/wefw/wef/ I’m thinking of doing something like:… Read More How to remove everything after first instance of specific delimiter, then before last instance of specific delimiter using Regex? – SQL
Advertisements I’m looking for a regular expression to implement a search and replace method which identifies strings like "/Sample Text:" in a longer text (e.g. "This is a /Sample Text: in a sentence"), where ‘Match whole word’ and/or ‘Match case’ can be specified. I’m new to regular expressions. Thank you very much. I tried something… Read More Search and replace method using regular expressions