I have a column in my ETL dataset that is named "City", in that column there are multiple city names however they have been put in in all different ways (ie: st george, St. George, ST George). I would like to search that column for rows containing 'george' and replace the information in that row with 'St. George'. I've figured out how to replace just the word I searched for but I can't figure out how to replace all the information in that row.
I have multiple different cities to do this with, St. George is just one example. I have created an ELT to do some other transformations with my data so I'd like to add this transformation in there as well.
I know there is a way to filter the column using the 'contains' comparison however I'm not trying to filter, I'm trying to replace text.
Can someone give me some advice on how to make this work?
Thanks!