UniqueGroupHeaders-urgent

RiaR

Hi<br />
<br />
I have attached a sample report with a csv file. Im using the following JS in my report to avoid email address<br />
<br />
function replace_custom(name){<br />
newstring = name.replace(/cc:[a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}/gi, "");<br />
newstring = newstring.replace(/[a-zA-Z0-9._-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,4}/gi, "");<br />
newstring = newstring.replace(/cc:[a-zA-Z0-9._-]/gi, "");<br />
return (newstring);<br />
}<br />
By executing this i can able to remove all email address of the column' NAME'. But while grouping this on column 'NAME' I am getting two repeated column headers. I need to make this into single.<br />
<br />
ie,<br />
This is wat i am getting<br />
<span class='bbc_underline'><strong class='bbc'>ABC</strong></span><br />
ABC<br />
ABC<br />
ABC<br />
<span class='bbc_underline'><strong class='bbc'>ABC</strong></span><br />
ABC <br />
<br />
I need the result to be like this<br />
<span class='bbc_underline'><strong class='bbc'>ABC</strong></span><br />
ABC <br />
ABC<br />
ABC<br />
ABC<br />
<br />
where i have to use the script to get the o/p as above?<br />
Thanks In advance

mwilliams

The problem you're running into is leftover spaces. On this particular example, if you add this line to your JS function, it'll work as you expect:

newstring = newstring.replace(" ","");

This may not work for a more complex example where your "Name" text has spaces in it, though. A workaround for a more complex example could be to create a computed column with this function, removing all spaces that you could to group on and use the original function to just get rid of the email addresses for display.