Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Expression for String Data display
JoshiS
I receive data in $$ separated array String which are separated further by comma, I want to display them in following fashion <br />
Name : value<br />
Addr : value<br />
City : value<br />
<br />
Name : value<br />
Addr : value<br />
City : value<br />
<br />
For this I am using following expression the columnName is SDR, which may contain N/A or blank values as well <br />
<br />
var myexp =/[$$]/;<br />
var comma =/[,]/;<br />
var match1 =comma.exec(dataSetRow["SDR"]);<br />
var match = myexp.exec(dataSetRow["SDR"]);<br />
if(match !=null)<br />
{<br />
array=dataSetRow["SDR"].split("$$");<br />
var string=null;<br />
for(var i=0; i<array.length; i++)<br />
{<br />
string+=array
+"nn";<br />
}<br />
dataSetRow["SDR"]=string.substring(4,string.length);<br />
}<br />
else<br />
{<br />
if(match1 !=null)<br />
{<br />
array1=dataSetRow["SDR"].split(",");<br />
var string=null;<br />
for(var i=0; i<array1.length; i++)<br />
{<br />
string+=array1
+"nn";<br />
}<br />
dataSetRow["SDR"]=string.substring(4,string.length);<br />
}<br />
<br />
else<br />
{<br />
dataSetRow["SDR"]=dataSetRow["SDR"];<br />
}<br />
}<br />
<br />
Can some one give solution ?
Find more posts tagged with
Comments
JasonW
Can you post an example of what the string looks like?