Removing certain words from a string

ksampson

I want to remove certain words from a string based on a long list that I have.

So example string 

Record 1: The road was a long winding and grey. With an yellow wall -

Record 2: The road was a long winding and blue. With an orange wall 

Words to pull out 

Yellow 

Grey

Orange

Blue 

Purple

Result 

Record 1: Grey / Yellow

Record 2: Blue / Orange

I have tried the append field on the find and replace however it only appends one result from example just grey 

AngelosPachis

Hi @ksampson ,

What you can do is use a text to columns tool to split each record to each constituent words. Then maybe you can remove any punctuations (.,-) and then with a Find & Replace tool look up for the values you want to keep

It's important to click the Case Insensitive Find button, so yellow can be picked up although you have defined Yellow as the word you are looking for.

Appending the fields to records will then allow you to filter out the nulls and concatenate the matched words together with a summarize tool.

Hope that helps, let me know if you have any questions on the workflow.

Regards,

Angelos

example.yxmd