Solved

Strip delimiters from Comments field

Posted on 2009-05-18
3
306 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

896 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

13 Experts available now in Live!

Get 1:1 Help Now