I’m trying to clean up an identifier column with a prefix at the start of the string. For example,
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.