Forum Discussion
Solved
Find text within a comma delimitated string
I have a column with comma delimitated data string: 1) abc 2) abc,xyz 3) idf,abc 4) pdq,abc,xyz 5) mabc,xyz 6) idf,abcd I am trying to show any data set with ID abc in it and i can pick out...
=OR(TEXTSPLIT(A1,",")="abc")
This is capturing any of the abc instances within the string even false ones.
Xabc,idk =true should be false
Idk,xabc = true should be false
I’m looking for a formula to filter these out and retain the abc w/o Any pre/postceeding characters
Xabc,idk =true should be false
Idk,xabc = true should be false
I’m looking for a formula to filter these out and retain the abc w/o Any pre/postceeding characters
Is this your expected outcome?
abc TRUE abc,xyz TRUE idf,abc TRUE pdq,abc,xyz TRUE mabc,xyz TRUE idf,abcd TRUE Xabc,idk FALSE Idk,xabc FALSE
abc TRUE
abc,xyz TRUE
idf,abc TRUE
pdq,abc,xyz TRUE
mabc,xyz ***FALSE***
idf,abcd ***FALSE***
Xabc,idk FALSE
Idk,xabc FALSE
Corrected to desired results=OR(TEXTSPLIT(A1,",")="abc")