Table has field containing the list of IDs separated by "-". Example: 559-3319-3537-4345-29923 I need to check rows that use at least 4 of the specified identifiers using regex Example: before inserting to the db, I need to check the…
I am using this Regex in my Flutter App to find words enclosed by single-quotes that end with a .tr: r"'[^'\]*(?:\.[^'\]*)*'s*.trb" Now I need another expression that is almost the same but looks for words enclosed by dobule-quotes, ending with…
I am trying to replace a dash between two time values and replace it with the word to but only if before the first time value there is the word from This is what I have until now, which works…
There are names of records in which are mixed several types of SKU that may contains symbols, digits, etc. Examples: Name of product 67304-4200-52-21 67304-4200-52 Name of product 67304-4200 Name of product 38927/6437 Name of product BKK1MBM06-02 Name of product…
There are names of records in which are mixed Cyrillic and Latin words, symbols, spaces, digits, etc. I need to preg_match (PHP) only Latin part with any symbols in any combinations. Test set: БлаблаБла Uty-223 Блабла (бла.)Бла CAROP-C Бла бла…
How do I replace part of url string without knowing beforehand what the string would be ? For example below is Ubuntu mirror. I want to set mirror to my liking. Basically, I want replace (jp, us provided as an…
I'm working on an nginx reverse proxy container image to proxy frontend files from s3, and Im trying to access these files from a specific folder location, instead of just the base path of the s3 bucket. As of yet…
Search in the array for the first occurrence of a string until space, then convert it to month. $arr = [ "May Hello", "Jun Hello12", "Jul 3" ]; $str = $arr[0]; $matches = []; $pattern = '/^w+s/'; preg_match_all($pattern, $str, $matches);…
I have the following string example: 034a412f500535454e5 Here I would get the 500 out. The search-string has always 8 digits in front and 8 digits behind. The "500" can have a different lenght of digits (p.ex. 12345). With a lot…
Following regex (s*select([^()]*)) giving all subqueries but it ignores when subquery contains any sql functions like max(), count(), ....etc regex works for below SELECT student.name, teacher.name, sub.subject_name FROM student student JOIN teacher teacher on teacher.id=student.teacher_id JOIN (select subject.name subject_name, subject.id…