Solved

Strip delimiters from Comments field

Posted on 2009-05-18
3
314 Views
Last Modified: 2013-11-27
Hi, I have a field returned in a report that points to =Fields!Comments.Value
This is a multiline field from Sharepoint.  When it is returned, the values are wrapped by <div> </div> Respectively if there is a value. eg.

<div>This is a comments test.</div>
Is there a way to strip the <div>/<div> to retun only what inbetween?
eg. This is a comments test.
0
Comment
Question by:DEN_Jimbo
3 Comments
 
LVL 6

Expert Comment

by:bull_rider
ID: 24413607
0
 

Author Comment

by:DEN_Jimbo
ID: 24413767
I am not sure how this would help.  I believe We have SQL2008 and I am using vs2005 to build the report.  I don't have access to upgrade or do anything on the server.  Isn't there a way to manipulate or strip the field?
0
 
LVL 16

Accepted Solution

by:
Auric1983 earned 250 total points
ID: 24423807
You could look at using the "replace" command and replace the <div> or </div> string with "" 
0

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

860 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