Calculated Column Substring - between 2 characters

Question

_{Thursday, June 9, 2016 10:29 AM}

Hi All ,

I have a requirment where i have to extract the text from between the 2 strings.

Please help me with the formula 

Text = "/sites/test/ListName/foldername/subfoldername"

I need to extract "foldername" from the above string using calculated column.

Thanks in Advance

Pallavi

All replies (2)

_{Friday, June 10, 2016 6:37 AM ✅Answered | 2 votes}

Hi Pallavi,

You could use the mid function to extract the sub string from the main string by specify the start number and the number of the substring.

For example the string below, the formula: MID([Text],22,10)

Text = "/sites/test/ListName/foldername/subfoldername"

For more detailed information, you could refer to the article below.

MID function.

https://support.office.com/en-us/article/MID-function-2eba57be-0c05-4bdc-bf81-5ecf4421eb8a?queryid=dd75ccca-9523-43d8-b04b-d9abe566cc01&respos=149&CTT=1&tduid=(ce7d9039384e5766182ef292243d1d03)(256380)(2459594)(TnL5HPStwNw-BBanLtHsC2nh4Cw7SS1PNg)()&CorrelationId=b95efe09-aca6-4ddd-8fdd-e5f4e52481f2&ui=en-US&rs=en-US&ad=US

More references:

Text Formulas for the Calculated Column.

https://sharepointdiva.wordpress.com/2012/09/06/text-formulas-for-the-calculated-column/

Using Calculated Columns to do a split string.

https://sarpoint.wordpress.com/2011/07/26/using-calculated-columns-to-do-a-split-string/

Best regards,

Sara Fan

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].

_{Friday, June 10, 2016 7:13 AM}

Sara,

That's all well and good if the word they're trying to get is only 10 characters long, also if ANY other text value before that changes.. This might not be a good job for a calculated column. You'll be best having a workflow run and do all the manipulation there.

If this is helpful please mark it so. Also if this solved your problem mark as answer.