Solved

Calculated column formula to remove unwanted characters

Posted on 2014-04-23
2
3,668 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
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 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

11 Experts available now in Live!

Get 1:1 Help Now