Filtering String Data

[shungui]

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!

[binuacs · Accepted solution]

@shungui 

[atcodedog05]

Hi @shungui 

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

Happy to help : )

[shungui]

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

[atcodedog05]

Hi @shungui 

Just provide the data in the image outputted to a excel file.

[shungui]

Please see attached. I'm trying to replace anything with a "CY" note to convert to "PY" descriptions and amounts. 

Essentially, last year's "CY" balances are now this year's "PY" balances

[binuacs]

@shungui are you looking for something like below

[atcodedog05 · Accepted solution]

Hi @shungui 

Hope this is what you are looking for

Hope this helps : )

[shungui]

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

[atcodedog05]

Happy to help : ) @shungui 

Cheers and have a nice day!