Split SharePoint column into 3 calculated columns using delimiter

Yatin Purohit 21 Reputation points
2021-04-26T05:47:41.707+00:00

In a SharePoint custom list called Vehicles, I have the column Title which is enrtered by a user.

The user will enter data as <car>-<model>-<trim>. For example, BMW-5 Series-530i Sport. I want 3 calculated populated - Make, Model, Trim, in my example the values will be BMW, 5 Series, 530i Sport in respective columns. I was hoping a combination of LEFT, RIGHT, FIND would work, but I am not able get the right formulas. Can someone help?

I am looking for native SharePoint calculated column formula and not any type of script or code. Thanks in advance.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
5,994 questions
No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 24,311 Reputation points Microsoft Employee
    2021-04-26T10:00:03.233+00:00

    @Yatin Purohit

    1.In the "car" calculated column, please use following formula.

    LEFT([test],FIND("-",[test])-1)  
    

    2.In the "model" calculated column, please use following formula.

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

    3.In the "trim" calculated column, please use following formula.

    RIGHT(RIGHT([Title],LEN([Title])-FIND("-",[Title])),LEN(RIGHT([Title],LEN([Title])-FIND("-",[Title])))-FIND("-",RIGHT([Title],LEN([Title])-FIND("-",[Title]))))  
    

    4.Result.
    91312-1.png


    If an Answer is helpful, please click "Accept Answer" and upvote it
    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.


0 additional answers

Sort by: Most helpful