tableau正则表达式匹配指定字符前几位

1) tableau正则

REGEXP_EXTRACT(str([score]),"(\d{4}/\d{1,2}/\d{1,2})")
REGEXP_EXTRACT(str([score]),"(\d+(\.\d+)?)”

2) tableau正则提取字符前两位前几位：

REGEXP_EXTRACT("人教版八年级语文abcd","版(.+年级)")
REGEXP_EXTRACT("人教版八年级语文abcd","([^;])年级")+"年级"

3) tableau正则提取多个数字：

REGEXP_REPLACE("CFE17083101/CFM17083101","\D",char(10))
REGEXP_EXTRACT("日本早稻田大学九年级语文english","(([^;])年级)")

4) tableau正则匹配两个字符中间部分

else REGEXP_EXTRACT(STR([公司地址]),"省(.*)市") END

5) python正则领宽断言

import re
p = re.compile('(?<=省).*')
print(p.findall('江苏省连云港市'))

6) mysql正则提取包含指定字符

AND pu.company_name REGEXP '^((?!普柏特).)*$'
 
//查出开头不为a、b、c开头的用户 select id,user from users where username not regexp '^a.|^b.|^c.';

7) 自定义函数mysql regex_replace function

DELIMITER $$
CREATE FUNCTION `regex_replace`(pattern VARCHAR(1000),replacement VARCHAR(1000),original VARCHAR(1000))
RETURNS VARCHAR(1000)
DETERMINISTICBEGIN
DECLARE temp VARCHAR(1000);
DECLARE ch VARCHAR(1);
DECLARE i INT;
SET i = 1;
SET temp = '';
IF original REGEXP pattern THEN
loop_label: LOOP
IF i>CHAR_LENGTH(original) THEN
LEAVE loop_label;
END IF;
SET ch = SUBSTRING(original,i,1);
IF NOT ch REGEXP pattern THEN
SET temp = CONCAT(temp,ch);
ELSE
SET temp = CONCAT(temp,replacement);
END IF;
SET i=i+1;
END LOOP;
ELSE
SET temp = original;
END IF;
RETURN temp;
END$$DELIMITER ;