SP Calculated column to grab value between two delimiters

SharePoint Automation 1 Reputation point

Hello, I have a unique id column using a Work Breakdown Structure. I would like to make a calculated column that pulls whatever is in between 2 periods.

I5.XYZ.241234 should grab "XYZ"
I7.R&DFINTECH.149876 should grab "R&DFINTECH"

218716-image.png should grab "PIC"

Thought this would be a couple of splits and id be done with it but apparently not!

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,563 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Dillon Silzer 52,906 Reputation points

    My solution might not be the cleanest way but it gets the job done. If it helps you please don't forget to accept as answer. Thanks!


    Create a column to extract everything after the first character (I called my TitleCalc)


    Create a column to extract everything after the first character of TitleCalc (I called my TitleCalc2)


    You can then hide the TitleCalc column as seen below:


    How to create calculated column:


    Formulas cited from:


    0 comments No comments

  2. Xuyan Ding - MSFT 7,561 Reputation points

    Hi @SharePoint Automation ,

    You could try the following code.

    =LEFT(RIGHT(Title, LEN(Title)-FIND(".",Title)),FIND(".",RIGHT(Title, LEN(Title)-FIND(".",Title)))-1)  

    218795-image.png 218808-image.png

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.