I’m trying to clean up an identifier column with a prefix at the start of the string. For example,
Input
a) AB1001
b) BAC1002
c) AA102E
Output
a) 1001
b) 1002
c)102E
I couldn’t find a regex function in QuickSight to do this (i thought this is a very basic function). The alternative is to use the ‘replace’ function, but I have over 20 prefix combinations so it is not efficient.
I also don’t have access to the SQL to use regexp_replace.
Appreciate it if anyone has a solution to this? Thanks.