FILTER DATA USING NESTED FINDSTRING

I have string values that I'm attempting to trap in my excel file. The string would be found in a free form text field named "Additional Issue Details". I would like to write one nested FINDSTRING formula which would search the field and when the whole word is found, e.g. "DATA", "FILE", ETC. that row of data would be flagged and the string that was matched is returned in a column titled "DATAMATCH".

My formula below appears to have the correct syntax but it's not returning the expected values.

Preparation

Data Investigation

Accepted answers

atcodedog05

Hi @mpressive6

If you are looking for searching whole word only and the word should not be part of any other word(ex: data system is ok but datasytem is not ok) below is how you can do it. I have padded them with space to search it as whole words.

Hope this helps : )

Data File.yxmd

All comments

Luke_C

Hi @mpressive6

I tried this out and didn't see an issue on my end. Can you share some sample data that's not working as expected? Have you tried the contains() function?

saveeshkumar

Hi @mpressive6 ,

You can convert both strings to upper or lower ..

plz find attachment for ref.

hope this help you

Thanks.

Qiu

@mpressive6
If you could use Contains function, we can choose the option of case insensitive.

0225-mpressive6.yxmd

atcodedog05

Hi @mpressive6

Hope this helps : )

Data File.yxmd

mpressive6

I just wanted to report back and say thank you to both Qiu and atcodedog05. The combination of their proposals did the trick and taught me approaches that I believe I will be able to leverage for other projects as I continue my Alteryx learnings.

atcodedog05

Happy to help : ) @mpressive6

Cheers and have a nice day!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235