title: Remove certain characters in a column Snowflake
body: <p>I am having data in a column like 'EARTH PLANET-ABC', 'MARS PLANET - ABC', 'JUPITER -ABC', 'VENUS- ABC' etc. I need to return the values 'EARTH PLANET', 'MARS', 'JUPITER', VENUS etc whenver the column has ABC at the end of the column. I tried <code>REPLACE(COLUMN_NAME,'ABC','')</code>. It removed the ABC from the entries in the column but it still returns the '-' and the space before/front of the ABC in the entry. I want to see EARTH PLANET', 'MARS', 'JUPITER', VENUS but I am getting 'EARTH PLANET-','MARS PLANET - ','JUPITER -','VENUS-' etc instead. Would a REGEXP help in this case?</p>