Informer script (to be placed in a calculated column) that can replace pipe (“|”) characters so they do not affect exported results.
Today I worked out how to transpose SQL dates (copied from SQL Server) in Microsoft Word…..
I have just found a very useful article from SQLServerCentral.com, that goes through the process of replacing multiple spaces with one. “Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here’s a set based method for replacing multiple spaces from MVP Jeff Moden” http://www.sqlservercentral.com/articles/T-SQL/68378/