Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

If I have a docuent library that has a documents in it using the following format: Region_Division_Store.pdf ...notice the underscores.

I also have three columns named Region, Division, Store. These columns are calculated based on the Title Column.

The documents will be added via the email to list capability.

How can i go about setting the column texts by seperating the string at the underscore.

at this time i am able to get the index of the first underscore using =SEARCH("_",Title,1), but this only gives me the index of the first underscore

Any and all help will definitley be appreciated

share|improve this question

1 Answer 1

Assuming your Title field has Region_Division_Store format, here is how it can be done.

Region -- =LEFT(Title,FIND("_",Title)-1)

Division--

=RIGHT(LEFT(Title,FIND("_",Title,FIND("_",Title)+1)-1),FIND("_",Title)+1)

Store--

=RIGHT(Title,LEN(Title)-FIND("_",Title,FIND("_",Title)+1))
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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