mikaelsnavy of CaseTrakker Dynamo Snips
11/18/2015 - 10:31 PM

Format Event Text for CSV Reports

Format Event Text for CSV Reports

format_text_for_reports.sql
content_copyfile_download
/* Remove newline and commas from result */
SELECT TOP 10
  REPLACE(REPLACE(REPLACE(CAST(ct_note.text AS VARCHAR(MAX)), ',', ' '), CHAR(13), ' '), CHAR(10), ' ')
FROM
  ct_note WITH (NOLOCK)