Hello,
I'm trying to grab the 8 digit number from the "Orig 1st Ref" column in my workflow via a REGEX_Replace formula, but I can't seem to get the syntax correctly.
If my "Orig 1st Ref" value is something like "Random Word/12345678-001" then the below formula will return "Random Word/-001" when in reality I am just trying to get it to return 12345678 (the 8 digit number only) as the final result.
Please help me out - I'd really like to use the formula tool and not result to using the "Regex" tool is at all possible - I feel like there definitely is a way to do this, but I'm matching the 8 digits, not matching everything but the 8 digits which is my problem.
Current Regex_Replace formula:
if IsEmpty([Project #]) and [AtLeast8#s]>=1 then
REGEX_Replace([orig 1st Ref], "\b\d{8}\b","$1")
else [Project #]
endif
Thanks,
taxguy33
This should work:
REGEX_Replace(
REGEX_Replace([text],'.+?(?=\b\d{8}\b)',''),
'(?<=\b\d{8}\b).*$','')
Hi @taxguy33, maybe this one works for you: REGEX_Replace([Field1], '.+\/(\d{8})-\d+', '$1')