Solved

Calculated column formula to remove unwanted characters

Posted on 2014-04-23
2
4,377 Views
Last Modified: 2014-04-24
I have a value copied to a text field from a managed metadata column. It is in the following format:

457;#Some text here

How can I remove # and everything else on the left and keep "Some text here" only using a formula in a calculated column?
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 Comments
 
LVL 31

Accepted Solution

by:
Jamie McAllister MVP earned 450 total points
ID: 40019402
According to the answer referenced below, creating a second calculated column something like this should work;

=RIGHT([Your Calculated Column],LEN([Your Calculated Column])-INT(FIND("#",[Your Calculated Column])))


http://sharepoint.stackexchange.com/questions/29140/using-calculated-field-to-retrieve-substring-of-another-field

http://stackoverflow.com/questions/10272842/sharepoint-trim-column-up-to-specific-character
0
 

Author Comment

by:MisUszatek
ID: 40020464
Thanks - it worked!
0

Featured Post

Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

Question has a verified solution.

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

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
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...
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

740 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