Finding Text from a ntext colum

Hi All,

I am sure this is easy but I have been scratching my head for a while. I am new to BIRT

I want to display just the Flicker URL from this embedded html pulled form the xtext column. It's the second URL I need.

href="http://www.flickr.com/people/40754330@N03/" target="_blank">Gustavo Mazzarollo</a><br> <strong>Added:</strong> 11/13/11 <strong>Taken:</strong> 11/13/11 <strong>Last Updated:</strong> 3/21/12<br> <strong>Latitude:</strong> -29.408422&nbsp<strong>Longitude:</strong> -51.846798<br> <strong>Tags:</strong> birds<br> <strong>License:</strong> All Rights Reserved </div> </div> <div style="position:absolute;top:0;left:0;text-align:center;width:120px;"> <div style="margin-bottom: 5px;"> <img src="http://farm7.static.flickr.com/6227/6339598999_cd472d5a46_t.jpg" alt="Birds"> </div> <div style="background-image: url(/images/ci/ng/rumble_button_back.gif);background-position: center; padding: 2px; text-decoration: none; color: #333333; text-align: center; border: 1px solid #BBBBBB;"> <a class="lb" lb:options="{'contents':{'id':'myFlickr6339598999','stripComments':true},'closeOnBodyClick':false}" style="text-decoration: none; color: #333333;" href="http://www.flickr.com/photos/40754330@N03/6339598999/" target="_blank" title="Birds">View Photo</a> </div> </div>

With the title I want the first one so I have been using the expression

var testing = BirtStr.charLength(dataSetRow["main_data"])
var spaceCharPosition = BirtStr.indexOf( "title", dataSetRow["main_data"] );
var comb = testing - spaceCharPosition - 7;
var ddddd = BirtStr.right(dataSetRow["main_data"], comb);
var stringPatternPosition = BirtStr.search("src", ddddd);
var string1 = stringPatternPosition -7;
displayString1 = BirtStr.left(ddddd,string1 );

I want to know how to pull out only the second url. I am sure I am overcomplicated this

Thanks for looking

Andy

Find more posts tagged with

Comments

hulmea

I used a rather ugly fix for this but it works.

var testing = BirtStr.charLength(dataSetRow["main_data"])
var spaceCharPosition = BirtStr.indexOf( "href", dataSetRow["main_data"] );
var comb = testing - spaceCharPosition;
var ddddd = BirtStr.right(dataSetRow["main_data"], comb);
var stringPatternPosition = BirtStr.search(" ", ddddd);
var displayString1 = BirtStr.left(ddddd,stringPatternPosition );
var checksizebts1= BirtStr.charLength(displayString1);
if (checksizebts1 < 50)
{
startofnexttxt =(spaceCharPosition + checksizebts1);
comb2 = testing - startofnexttxt;
nextxt = BirtStr.right(dataSetRow["main_data"], comb2);
totalchartxttxt = BirtStr.charLength(nextxt);
spaceCharPosition = BirtStr.indexOf( "href", nextxt );
comb2 = totalchartxttxt - spaceCharPosition -6;
nexttxt3 = BirtStr.right(nextxt, comb2);
stringPatternPosition = BirtStr.search(" ", nexttxt3) -1;
displayString2 = BirtStr.left(nexttxt3,stringPatternPosition );
}
else
{}