regexp-replace – Tarik Billa

Extract numbers from a field in PostgreSQL

November 28, 2023 by Tarik

Simply: SELECT NULLIF(regexp_replace(po_number, ‘\D’,”,’g’), ”)::numeric AS result FROM tbl; \D being the class shorthand for “not a digit”. And you need the 4th parameter ‘g’ (for “globally”) to replace all occurrences. Details in the manual. For a known, limited set of characters to replace, plain string manipulation functions like replace() or translate() are substantially cheaper. … Read more

Laravel preg_match(): No ending delimiter ‘/’ found

April 14, 2023 by Tarik

Since your regex has a pipe in it, you have to use an array: public static $rules_save = [ ‘class_subjects’ => [‘required’, ‘regex:/[0-9]([0-9]|-(?!-))+/’], ]; From the docs: When using the regex pattern, it may be necessary to specify rules in an array instead of using pipe delimiters, especially if the regular expression contains a pipe … Read more