Hi community,
I'm trying to remove the text from the middle of a string. I've managed to trim characters from both the left and the right already.
What looked like this: CAT_CAT_0107_03_03_000 now looks like CAT 0107, but I need it to look like 'CAT107'.
The data type is string and needs to remain string.
Thanks a lot in advance,
Matt
Solved! Go to Solution.
Hi @Blondek ,
I'm not sure if I'm simplifying your problem, let me know if I'm doing it.
Best,
Fernando Vizcaino
Regex_replace([Field],' 0*','')
This will remove any spaces and any zeroes preceded by a space
This worked perfectly, thank you!