How to exact substring from string using index value in SharePoint 2010 workflow

Question

How to create workflow where two substring can be exacted from one and can be saved in two different column of the list. I have title like arrow_black, I want to exact arrow and black from this title.

Something like this in SharePoint using workflow

Please note: I want to implement this in SharePoint 2010

Title:- Arrow_black

Icon :- Arrow

Color:- Black

Thanks!

Answer 1

You should be able to accomplish what you want by using calculated columns, tedious I know but sometimes that's just SharePoint.

Try the following link to get the formula that you want to put in your columns

Using calculated field to retrieve substring of another field