Hi there, I want to fix a Regex formula, but bumping into a challenge I can not fix. We have a text field with a product name. This can be: The Ultimate Workspace The Ultimate Workspace - payment in 3 installments I want a formula that extracts everything prior to " - …" (including the blank sp…

Well, it actually can be done simply with regex replace as well. ReplaceRegex(TextField, "-.*", "")

[image] Marloes: So the result will be “The Next Level”. The result will be 'The Ultimate Workspace", no?

If you are sure that the first hyphen in the string is always the one you want to separate at, then I would suggest the following: Left(TextField,Find(TextField,"-")-1)

[image] Chr1sG: The result will be 'The Ultimate Workspace", no? Yes. We use with testing all those products interchangeably so accidentally misnamed. :see_no_evil: [image] Chr1sG: Left(TextField,Find(TextField,“-”)-1) PERFECT!!

Only challenge left. We sometimes have ‘The Ultimate Workspace’ and sometimes we have ‘The Ultimate Workspace - payment in 3 installments’. If I use this formula, ‘The Ultimate Workspace’ will become ‘The Ultimate Workspac’ due to the -1. Tried to modify, but didn’t find the right solution.

Yeah, sorry. You probably need something this then: If(Find(TextField,"-")=0,TextField,Left(TextField,Find(TextField,"-")-1)

No sorry! Was trying something like this, but because I wasn’t using the find function, my formula came up negative. This is perfect! Thanks again.

Regex Formula to extract part of a text

Get Help

Topic		Replies	Views
Modify a Left - formula Get Help	3	336	April 18, 2023
Extract part of entity name Get Help	2	253	April 4, 2023
Extracting name from text Misc	8	314	September 22, 2023
Split Function for Formula Ideas & Features formulas	19	567	March 5, 2025
Converting text to a number API & Programming	12	193	March 20, 2025

Regex Formula to extract part of a text

Related topics