Home
Events
Groups
Members

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
Gtm Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Powered by Tightknit

Trouble Normalizing Hotel Names? Find Solutions Here. | Clay

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

5 comments

· Sorted by Oldest

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