Solved

Sharepoint Calculated Field - extract piece of text from another field

Posted on 2012-03-29
2
885 Views
Last Modified: 2012-04-20
I have a field with a value at the before a "-" that varies in length and text after the dash. I would like to get a sub set of the portion before the dash. I've seen comments on how to extract after a certain point but not before and not if the length varies.

Sample:

OLB-20           in original field

OLB                should be in calculated field

OLBad-1539   in original field

OLBad            should be in calculated field
0
Comment
Question by:BearWebContent
2 Comments
 

Author Comment

by:BearWebContent
ID: 37785038
Never mind. I figured it out. "-" being whatever point you want to end at.

=MID([Col1],1,FIND("-",[Col1],1)-1)
0
 

Accepted Solution

by:
EE_AutoDeleter earned 0 total points
ID: 37874482
Because this question has no expert participation and is over 21 days old, it would have been deleted automatically, but you have posted information yourself making this PAQ-worthy.

EE_AutoDeleter
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question