Hi Guys
From the databse I am getting four columns. One of the colums is of type CLOB. I am converting this data to a string. Now this String text has lot of nodes, now what I need is to show only the values of between <Description locale="en_US" type="admin"> and </Description>.
Would anyone know how I can use substring to display only description value. I have pasted a sample of how the Column data will be and also the jstl code of how I show the values.
I would reallly appreciate any help regarding this
<c:forEach var="elements" items="${reportResult}">
<tr>
<c:forTokens items="${elements}" delims="," var="current" varStatus="sts">
<c:if test ="${sts.count==1}">
<td width = "50px" align="left" class="alt-color" >
<c:out value="${current}" />
</c:if>
.....
<c:if test ="${sts.count==5}">
<td width = "290px" align="left" class="alt-color" >
<c:out value="${current}" />
</c:if>
</c:forTokens>
--------------------------
----------
----------
------
<?xml version="1.0" encoding="UTF-8"?><Promoti
on impl="com.ibm.commerce.mar
keting.pro
motion.Def
aultPromot
ion"><Prom
otionKey><
PromotionN
ame>C1</Pr
omotionNam
e><StoreKe
y><DN>ou=b
2c,o=selle
r organization,o=root organization</DN><Identifi
er>srsstor
e1</Identi
fier></Sto
reKey><Ver
sion>1</Ve
rsion><Rev
ision>2</R
evision></
PromotionK
ey><Promot
ionGroupKe
y><GroupNa
me>Product
LevelPromo
tion</Grou
pName><Sto
reKey><DN>
ou=b2c,o=s
eller organization,o=root organization</DN><Identifi
er>srsstor
e1</Identi
fier></Sto
reKey></Pr
omotionGro
upKey><Typ
edNLDescri
ption impl="com.ibm.commerce.mar
keting.pro
motion.Typ
edNLDescri
ption"><De
faultLocal
e>en_US</D
efaultLoca
le><Descri
ption locale="en_US" type="admin">Get 40% of the highest priced item in the shop cart</Description><Descrip
tion locale="en_US" type="long">Get 40% of the highest priced item in the shop cart</Description><Descrip
tion locale="en_US" type="short">Get 40% of the highest priced item in the shop cart</Description></TypedN
LDescripti
on><Priori
ty>200</Pr
iority><Ex
clusive>0<
/Exclusive
><ExemptPo
licyList/>
<Explicitl
yAppliedPo
licyList/>
<Status>1<
/Status><L
astUpdate>
20-04-2007
07:54:59</LastUpdate><Last
UpdateBy><
CustomerKe
y><LogonId
>wcsadmin<
/LogonId><
/CustomerK
ey></LastU
pdateBy><P
erOrderLim
it>1</PerO
rderLimit>
<PerShoppe
rLimit>-1<
/PerShoppe
rLimit><Ap
plicationL
imit>-1</A
pplication
Limit><Tar
getSales>0
</TargetSa
les><Corre
spondingRB
DTypeName>
ItemLevelP
ercentDisc
ount</Corr
espondingR
BDTypeName
><Schedule
impl="com.ibm.commerce.mar
keting.pro
motion.sch
edule.Prom
otionSched
ule"><Date
Range impl="com.ibm.commerce.mar
keting.pro
motion.sch
edule.Date
RangeSched
ule"> ...