I'm joining accounts numbers (Cuentas) in V_String type. No case in here.
Change data type, used the formula "REGEX_REPLACE([CUENTA],'[\x0-\x1f]','')", used the Data cleansing
I'm not able to upload the input data as it's sensitive information.
But I'm trying to figure out what are the options. Been doing my research and couldn't find much but the 2 options above.
In case you have seen similar cases and how they were solve I'd appreciate.