Filtering String Data

Hi All,

I've tried other options offered in older posts and it's not working for me. Can someone please help me filter the below table of data with anything containing "CY" in the "E&P ADJUSTMENT DESCRIPTION" field? I've already tried filtering by CONTAINTS("CY") and nothing works.

My goal is to isolate items noted with the "CY" note and then replace the value to say "PY" down the chain... I'm at a total loss.

Thank you!

Workflow

Tips and Tricks

Best Practices

Accepted answers

Hope this is what you are looking for

Hope this helps : )

All comments

can you provide data in a file we can build a workflow for you with your data.

Happy to help : )

Thank you for offering. How do I do that? This is a large workflow with lots of inputs, as well as confidential information therein.

@shungui are you looking for something like below

Thank you @atcodedog05 and @binu_acs !! I really appreciate your fast and thorough answers/solutions!

Happy to help : ) @shungui

Cheers and have a nice day!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703