Assuming that the phrase always starts with (, and no other part of the text will have parantheses, you could use this formula:
LEFT({Field name}, FIND({Field name}, ' ('))
^ Its selecting all the text to the left of the first time [space]( appears
Assuming that the phrase always starts with (, and no other part of the text will have parantheses, you could use this formula:
LEFT({Field name}, FIND({Field name}, ' ('))
^ Its selecting all the text to the left of the first time [space]( appears
Does not seem to work. Leaves every field blank, even though the formula doesn’t return an error
Does not seem to work. Leaves every field blank, even though the formula doesn’t return an error
Is {Field name} a Lookup or Rollup field? If so, you can fix it like this:
LEFT({Field name}&'', FIND({Field name}&'', ' ('))
Is {Field name} a Lookup or Rollup field? If so, you can fix it like this:
LEFT({Field name}&'', FIND({Field name}&'', ' ('))
Nope - tried that and no dice. It is a text field.
Nope - tried that and no dice. It is a text field.
Sorry, I had the Find formula backwards:
TRIM(LEFT({Field name}, FIND(' (', {Field name})))
(I have now wrapped everything in a TRIM() to remove any trailing space at the end)
Sorry, I had the Find formula backwards:
TRIM(LEFT({Field name}, FIND(' (', {Field name})))
(I have now wrapped everything in a TRIM() to remove any trailing space at the end)
Ok Awesome - this works IF there is a title that has a Parenthetical.
However, for titles that do not have a parenthetical, it returns an empty text field.
Is there a way to apply this formula only if there is a parenthetical, and otherwise simply copy over the title as is?
Ok Awesome - this works IF there is a title that has a Parenthetical.
However, for titles that do not have a parenthetical, it returns an empty text field.
Is there a way to apply this formula only if there is a parenthetical, and otherwise simply copy over the title as is?
You can wrap it in an IF() to only apply to titles with a (
IF(FIND(' (', Name), TRIM(LEFT(Name, FIND(' (', Name))), Name)
You can wrap it in an IF() to only apply to titles with a (
IF(FIND(' (', Name), TRIM(LEFT(Name, FIND(' (', Name))), Name)
Thank you! This worked perfectly
