REGEX Replace

[marta-anastasiia]

Hi Guys, I hope u all doing well.

I have a text as 2023 bluess&cloud Sft Medium 12*114g and I want how can i get the values till second pipe from the end using Regex_Replace formula or tool,

required output is 12*114g please help with the Regex formula. Thanks.

[lwolfie]

You can try using something like this:   \s(\d{2}\*\d{3}.+)  

Using the \ infront of the star makes Alteryx look at it as a character and not as the any character.

[binuacs]

@marta-anastasiia