title: Use multiple replace conditions for a single column in Amazon Redshift
body: <p>I have a table where the amount column has , and $ sign for example: $8,122.14 as values. I want to write a replace function to replace $ and , over that column in one go. Is there any way we can write multiple conditions in one replace in Redshift? Also, this is apart of post processing the data where I am inserting data from stage table to a final table after replacing these values.</p>
  
  <p>I tried the ways listed in the take 1 and 2 given in the code but both of them failed.</p>
  
  <p>Take 1: 
      insert into db.stage_table
      select 
      (coalesce(replace(logging_amount,'$',','),''))) as logging_amount
      from db.table;</p>
  
  <p>Take 2: 
      insert into db.stage_table
      select 
      (coalesce(replace(logging_amount,'$',',')) as logging_amount
      from db.table;</p>
  
  <p>Both of them failed.</p>
  
  <p>The expected result should be replace function in a single statement.</p>