Forum Discussion
AlejandroPCar
Helper IV
Helper IVData Wrangling with Query Editor
Hi! I have a tedious problem with some "raw" data here. I have a list of companies names with several differents names for a same companie i.e. A companie named "Muebles S.A." can be found with ...
So, yes, you can replace values in Query Editor, do things like Trim, Clean, Capitalize, etc. Just right click the column in Query Editor and choose Transform for many of these. For the specific case below, if you did a "Capitalize Each Word" and replace "." with "" and spaces with "" then you should get them all into "MueblesSA"
Greg_Deckler
Community Champion
Community ChampionSo, yes, you can replace values in Query Editor, do things like Trim, Clean, Capitalize, etc. Just right click the column in Query Editor and choose Transform for many of these. For the specific case below, if you did a "Capitalize Each Word" and replace "." with "" and spaces with "" then you should get them all into "MueblesSA"