Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Use a calculated field to extract part of text from another field in the same entity

Posted on by 211

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

  • Suggested answer
    crm development Profile Picture
    crm development 870 on at
    RE: Use a calculated field to extract part of text from another field in the same entity

    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.

  • MichelleM Profile Picture
    MichelleM 211 on at
    RE: Use a calculated field to extract part of text from another field in the same entity

    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.

  • Suggested answer
    crm development Profile Picture
    crm development 870 on at
    RE: Use a calculated field to extract part of text from another field in the same entity

    Hi Michelle,

    You can use OOTB 'TrimLeft' and 'TrimRight' formulas while setting Action in calculated field.

    Thanks,

    Anand

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans