Solved

Sharepoint Calculated Field - extract piece of text from another field

Posted on 2012-03-29
2
883 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now