Can I extract part of the text from another field and pull it into a calculated field?
The part of the text I am trying to extract is in brackets and always starts with the same 4 letters. I don't want the brackets to copy across but what is within them.
Can I use a formula similar to one you would use in Excel?
*This post is locked for comments
okay. In this case, you can write regular javascript to extract characters and populate it in any new hidden field. Later use this hidden field in Calculated field.
Hmmm I did try that but it only allows you to trim by a number of characters as far as I can tell. The number of characters before the part of text I am trying to extract will vary.
Hi Michelle,
You can use OOTB 'TrimLeft' and 'TrimRight' formulas while setting Action in calculated field.
Thanks,
Anand
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156