Need urgent help

[Sivory18]

Hello

I am wanting to remove the words after the number, so from "WHAT IT LOOKS LIKE" to "WHAT I WANT"

[Ritesh_Parmar]

you can use Regex_replace Refer workflow

REGEX_Replace([Field1], "([A-Z]+-\d+).*", "$1")

[Ritesh_Parmar]

logic : it captures the uppercase letters pattrn  followed by a hyphen and digits, and will removes everything after that.

[Sivory18]

Hi Ritesh, what formula would i use if there was something like
ACdDJWI-5023224-04-0114:56:13.120Dhwewidjwjfksowi[lfdfdfdf]2024-04-0116:20:35.960MID:ITSUPPORTRuntheactivityRIOT-615634ApprovedApproved

and want to only grab "RIOT615634" 

[binuacs]

@Sivory18 

REGEX_Replace([WHAT IT LOOKS LIKE], "^(.*?)(?=Approved).*", "$1")