0

I am working on a column in SharePoint List. Let's name this column as Column A. I need help to split this column by delimiter which is "-" into several columns. Here is the sample of column A:

    Column A          
    -----------------|
    5675-100345-9967
    7788556-5555-133
    50505-985-1000088

I need help to split this column by delimiter which is "-" into several columns. Really appreciate if anyone can help to solve this.

Tried to use LEFT or RIGHT function with calculated column but i think it is only useful when the digit is consistent.

Improve this question
2
  • can you please add your expected output?
    – Dhruvil Prajapati
    Commented May 22, 2020 at 4:29
  • Do you have any flow/workflow running on this list? it will be easy to separate it using workflow and save in different columns
    – Ganesh Sanap - MVP
    Commented May 22, 2020 at 4:58

1 Answer 1

Reset to default
1

We could use flow in SharePoint online to accomplish your requirement:

My test List:

enter image description here

My flow:

enter image description here

Compose function as shown below:

split(triggerBody()?['ColumnA'],'-')?[0]

split(triggerBody()?['ColumnA'],'-')?[1]

split(triggerBody()?['ColumnA'],'-')?[2]
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.