Solved

SharePoint 2010 calculated colum formula

Posted on 2013-12-20
3
380 Views
Last Modified: 2013-12-20
In one of my columns I have values starting with 1;#SomeText. How can I remove those 3 first characters (1;#) using a calculated column formula?
0
Comment
Question by:MisUszatek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 39732994
Hi,
i am currently mobile so no verification but should be
=right(column,len(column)-3)
0
 

Author Comment

by:MisUszatek
ID: 39733010
Works!
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39733055
Hi,
thanks for the points.
Now I am at my dev system and this is the more error prone solution, which will also work if your ids getting greater than one digit:
=RIGHT(Column,(LEN(Column)-IF(ISNUMBER(FIND("#",Column)),FIND("#",Column),0)))

Open in new window


HTH
Rainer
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

728 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