title: Redshift Translate command to replace characters
body: <p>I need to translate commas in a column to pipe with with spaces on each side in Redshift ('a,b,c'  becomes 'a | b | c' using Translate.  Something in this statement is not giving me my desired results and I can't figure out why?
  select 'a,b,c' as comma_string,  translate(comma_string, ',', ' | ' ) as pipe_string</p>
  <p>is yielding 'a b c' with no pipes.  Having trouble getting the space before and after the pipe as</p>
  <p>select 'a,b,c' as comma_string,  translate(comma_string, ',', '|' ) as pipe_string
  gives me 'a|b|c'</p>