Solved

Strip delimiters from Comments field

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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 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

20 Experts available now in Live!

Get 1:1 Help Now