What is the SQL query directly for this given use case: I want to get all records in the table that in their fields column which is of type text has pageTitle containing a specific string Table structure: This query…
I have a small PHP website with 3 pages. The page content is dynamically translated in Dutch or English (I take the language from the URL) index.php page-one.php page-two.php I want to achieve the following URL's https://www.example.com/ => https://www.example.com/en/ or…
Vue and Quasar frameworks String: "Lorem ipsum dolor sit amet CONSECTETUR adipiscing elit" Template The following code does not work <span:class=""> {{ highlightSearchExpression(string) }} /> Using v-html (works inconsistently; merge search word with other words) <span v-html="highlightSearchExpression(string)" :class="" /> Method…
I'm working with strings. The string often contains something like this: "The site https://example.com contains all the information you need" So far I have this regex, which splits the string when https? is found const rgx_link = /(?=https?://)/gi; So in…
I have a calculator and I want it to not start calculation until the expression seems to be correct. Seems to be correct means that it should not contain any non math symbols like $, # etc. I don't care…
I have paragraphs like this: "{~1.6} This is another paragraph {~1} with curly braces.{~6.8}" I want to match {~<int or float>} So far I've came to this regex: /{(~(d*.?d+),?)}/g It works just fine but sometimes there will be some other…
I am working on a Next.js project with authentication and am putting some URLs as strings into an array called protectedRoutes, so people get redirected when they access those URLs before they sign in. const protectedRoutes = ["/home", "/profile", etc.];…
I have a requirement to validate input using regex . Requirement is to match the string in form of tuples(a,b,c) or more than 3 (a,b,c,d,e) but white space can occur before/after string boundaries like below: t1 t2,t1 t1 , t2…
I have a Symfony validation constraint that removes all Twig tags with regular expressions before counting characters and validating based on character length limits. (My form allows people to enter a limited subset of Twig tags in a field.) So…
I am using this pattern for password validation. Validators.pattern('((?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[!"#$%&`{|}~()*+,-.\:/;<=>?@[\]^_/']).{10,})'), But this validation is not working for ,;() etc but working for!@#$%^& These characters are need to be accepted- !"#$%&'()*+,-./:;<=>?@[]^_`{|}~ Can anybody suggest where the error is?