Trouble Normalizing Hotel Names? Find Solutions Here.

·

Hey, I'm trying to normalize hotel names but it doesn't work at all. Is there something I should change? https://app.clay.com/workspaces/48925/tables/t_kQ3dqT6wM8sE/views/gv_XEfPLGKPzzzE

Clay Team
APP
·
·
Hey there Augustin sorry for the delay, let me take a look.
Clay Team
APP
·
·
Hey Augustin so looking at this table, is your concern is the fact that some of the words are not getting decapitalized? If it is, this is happening because the tool is still having trouble with some edge cases, which is being addressed. If you want a different approach to this problem than formulas also work at accomplishing this. You just need to give it a proper prompt and it will do same as "Normalize Name" integration. For example "Get the name from /name and decapitalize all the letters that are not the first letter in the word" should work.
Augustin R.
·
·
It's actually for hotel names that mention the city in the name. I want to take it out!
Clay Team
APP
·
·
Hey Augustine sorry for the long delay, the Chatgpt integration can help in regard. It is better at catching any edge cases that may pop up with our normalizing tool. using a prompt like "Look at the name from /Title and remove the name of the city it is in which can be found here /Address, if present in the name. " could perform the action you are looking for.
Augustin R.
·
·
Thanks! I'll try with a formula as it's cheaper