Trimming characters from the middle of a string

[Blondek]

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 solution]

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 solution]

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

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

[Blondek]

This worked perfectly, thank you!