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 · Accepted solution]

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

[ksampson]

 This is great is there any way to do this if there is no space

For example some sentences may look like this

Theroadwasalongwindingandgrey.Withanyellowwall 

[pedrodrfaria · Accepted solution]

Hi @ksampson 

Using a different logic, with no spaces, I think the best method would be the append fields. See attached for the WF.

Pedro.