replacing tab characters in a webreport

Kristy_Shen

Currently, I have a webreport which can export the data returned from the livereport into Excel. It uses tabs as delimiters. Thus, I need to replace any tab characters that are coming back from the database with spaces. I tried to use the REPLACE attribute in the Livelink tags but it doesn't recognize the tab character I copied into the webreport. I also tried to use:[LL_REPTAG=Details ESCAPESTR REPLACE: ESCAPESTR REPLACE:"\t":" " /]This works, but because I'm using ESCAPESTR, any quotes show up as the escaped version \"Is there some way I can replace the tabs with spaces, but not cause other characters from displaying as their escaped versions? I've also tried to do the replace in the sql but some of the fields are ntext and the built-in sql replace function is not supported for ntext. So it would be best to do it within the webreport.

Greg_Petti

Message from Greg Petti via eLinkHi,One thing you could try is placing double quotes around each cell:"[LL_REPTAG=Details /]"So that Excel will ignore any characters within the quotes. Out ofcuriosity is there any particular reason you are using tabs instead ofcommas? There is a sub-tag (which appears not to be in thedocumentation) called ESCAPECSV which can be used to automatically quotecells that have commas in them. This can also be used asESCAPECSV:ALLCELLS which would also make sure that any double quotes inthe cell would be appropriately escaped. One other way to manage what you are trying to do below would be to usethe PATCHANGE sub-tag that allows pattern matching. This would probablylook like this:[LL_REPTAG=Details PATCHANGE:@t:" " /]Greg-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: January-08-08 8:09 AMTo: eLink RecipientSubject: replacing tab characters in a webreportreplacing tab characters in a webreportPosted by Shen, Kristy on 01/08/2008 10:02 AMCurrently, I have a webreport which can export the data returned fromthe livereport into Excel. It uses tabs as delimiters. Thus, I need to replace any tab characters that are coming back from thedatabase with spaces. I tried to use the REPLACE attribute in theLivelink tags but it doesn't recognize the tab character I copied intothe webreport. I also tried to use:[LL_REPTAG=Details ESCAPESTR REPLACE: ESCAPESTR REPLACE:"\t":" " /]This works, but because I'm using ESCAPESTR, any quotes show up as theescaped version \"Is there some way I can replace the tabs with spaces, but not causeother characters from displaying as their escaped versions? I've alsotried to do the replace in the sql but some of the fields are ntext andthe built-in sql replace function is not supported for ntext. So itwould be best to do it within the webreport.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/Livelink_LiveReports_DiscussionLivelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.