REGEX Replace

Question

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.

binu_acs · Answer

@marta-anastasiia

lwolfie · Answer

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.