Hello!! Is there a way that I am able to use the Find and Replace tool to apply keyword searches that contain wildcards. The dataset I am working on contains a list of locations that are written in various ways. For example my dataset contains location data that is Bloggs Healthcare, Bloggs health, Bloggs Healthcare Ltd, Bloggs Healthcare Limited. I would like the keyword search to be Bloggs* (* being the wildcard, although not sure if it something different in Alteryx!) so that it appends all the rows where this is location is present as I don't know all the variations that it could be written in. I hope that makes sense, any ideas on how I am able to do this would be greatly appreciated!
