Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
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?