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.

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

should grab "PIC"

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

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)

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

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

=LEFT(TitleCalc,INT(FIND(".",TitleCalc)-1))

You can then hide the TitleCalc column as seen below:

How to create calculated column:

https://support.microsoft.com/en-us/office/calculate-data-in-lists-or-libraries-c5261743-667f-4833-bede-e516cef2a0e1

Formulas cited from:

https://sharepoint.stackexchange.com/questions/29140/using-calculated-field-to-retrieve-substring-of-another-field

Hi @SharePoint Automation ,

You could try the following code.

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

---

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.

Hi @SharePoint Automation ,

I’m checking how the things are going on about this issue. Whether the answer helps you?

Is there any progress on this thread? Please feel free to let me know.

Hi @SharePoint Automation ,

I am checking to see if the problem has been resolved . If you have any questions you can feel free to contact me.

Hi @SharePoint Automation ,
Is there anything else I can help with regarding this issue?
You can comment us at any time and we will continue to follow up.