Hello
I am wanting to remove the words after the number, so from "WHAT IT LOOKS LIKE" to "WHAT I WANT"
you can use Regex_replace Refer workflowREGEX_Replace([Field1], "([A-Z]+-\d+).*", "$1")
logic : it captures the uppercase letters pattrn followed by a hyphen and digits, and will removes everything after that.
Hi Ritesh, what formula would i use if there was something likeACdDJWI-5023224-04-0114:56:13.120Dhwewidjwjfksowi[lfdfdfdf]2024-04-0116:20:35.960MID:ITSUPPORTRuntheactivityRIOT-615634ApprovedApproved
and want to only grab "RIOT615634"
@Sivory18
REGEX_Replace([WHAT IT LOOKS LIKE], "^(.*?)(?=Approved).*", "$1")
