I need a regular expression that can contain Latin letters, digits, the underscore (_), the minus (-), and the point (.) symbols but the point symbol cannot be used as the first or the last symbol. I believe I need…
I have some urls with %20 (encoded space) inside. I have to remove %20. So, for example https://www.example.com/aaaa%20bbbb/page.html must become https://www.example.com/aaaabbbb/page.html I tried with this Apache rewrite rule: RewriteRule ^/([^%20]*)(?:%20)+(.*)$ /$1$2 [R=301] The problem is that first group stop on…
So far, I've come up with ORDER BY SUBSTRING(COLUMN FROM '[A-Z]+'), COALESCE(SUBSTRING(COLUMN FROM '(?<=-)[0-9]+')::INTEGER, 0), SUBSTRING(COLUMN FROM '(?<=()[0-9]+')::BIGINT Outcome Desired Outcome AC-1 AC-1 AC-2 (1) AC-2 AC-2 (2) AC-2 (1) AC-2 AC-2 (2) AC-3 (1) AC-3 (1) AC-3 (2) AC-3…
I have a document with contains ## for list sign. I want to replace ## with order numbers. first matched ## -> to 1. second matched ## -> 2. .... 3. .... 4. Is this possible to do in an…
I want to take all of the substrings inside of string which is between given two regex. Couple examples: My $$name$$ is John, my $$surname$$ is Doe -> should return [name, surname] My &&name&& is John, my &&surname&& is Doe…
I want to analyze texts for words and/or terms that don't include predefined syllables/letters but I don´t get the result I expect. I tried many things, my closest try was this for example. In the sentence (some things are no…
I want to remove numbers coming after every all type character except D in range, <F=..>. regex: (?:^<F=(?=.+>)|G(?!^)).*[^d]K[0-9]+ This able to capture number not coming after d. But, It not capture all that numbers at once. It capture from behind.…
I've tried ^[0-9]$ And ^d$ But they're allowing +,++ When tried ^[^+]*$ it is still allowing +
i'll start with an example because i'm not sure i can explain this properly. the easier part of the problem (i think although i can't get it either): take some strings eg. 'Example', 'DOMNode', 'DOMText', 'DOMElement' and output '(Example|DOM(Node|Text|Element))' a…
I have a regex to validate a decimal value before inserting into MySql database, but there is an issue with it. It is allowing a just the negative symbol with no digits after it. So for example, I'm validating against…