I need help with writing a regex for a column of mixed characters. I want to replace anything starting with PR followed by 4-5 numbers within the string with blank space. help me in writing the syntax for RegEx. this is the current ones I am using in Tableau:
REGEXP_REPLACE([PR Finder 3], '[^PR\d{4,5}]', '')
Please help
#tableau #regex #RegEx #syntax
REGEXP_REPLACE([PR Finder 3], '[^PR\d{4,5}]', '')
used this