Find and Retrieve Multiple Set Words Within a String

[JoeHodgetts]

Hello,

Looking for some help with the following.

I have string data that I want to search for pre-defined keywords and then add a column which lists all the keywords that were found. The string is not consistently separated by any particular delimiter and due to human error words can be concatenated. I've tried to crudely represent what I'm trying to achieve using notes on car damage.

I've seen some really good articles where people have solved similar queries using find and replace or RegEx, but none have been able to work with messy strings and recall every word found. 

Many thanks for any support.

Joe

[afv2688 · Accepted solution]

Hello @JoeHodgetts ,

It is not pretty but it does the work 🙂

Regards

[JoeHodgetts]

@afv2688 That is the ugliest, most beautiful solution I have seen. Thank you so much.

In practice the raw data is huge and with about 100 keywords, so hoping the initial append isn't too scary for it.

Joe 

[afv2688 · Accepted solution]

You were right @JoeHodgetts , was really ugly solution. Therefore I am bringing a better one 🙂

Regards

[JoeHodgetts]

@afv2688 I think this second method will handle a larger dataset better. Thank you 🙂

[Ben_H]

Hi @JoeHodgetts,

I think there's a slightly more straightforward way to do it, not that it makes much difference!

Regards,

Ben