Trimming characters from the middle of a string

Question

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

fmvizcaino · Accepted Answer

Hi @Blondek ,

I'm not sure if I'm simplifying your problem, let me know if I'm doing it.

Best,

Fernando Vizcaino

OllieClarke · Accepted Answer

Regex_replace([Field],' 0*','')

This will remove any spaces and any zeroes preceded by a space