Forum Discussion
Anonymous
7 years agoNot applicable
Text Search
Good afternoon
Does anyone know how I do (what formula I use) to search the fields that have a certain fragment of a text?
For example, I need to know which rows in the "Description" field of a table have the "ABC" snippet.
DESCRIPTION TEST
ABCX Yes
ABDF No
AGFA No
AFGD No
If I use the IF formula it does not work because it would only search the field that has only the ABC section. But my goal is to know the lines that have this fragment, but not necessarily be ONLY it.Anonymous -
This should do the trick for you:
Column = SWITCH ( TRUE (), FIND ( "ABC", Table1[Description], 1, 0 ) = 1, "YES", "NO" )
1 Reply
- ChrisMendozaResident Rockstar
Anonymous -
This should do the trick for you:
Column = SWITCH ( TRUE (), FIND ( "ABC", Table1[Description], 1, 0 ) = 1, "YES", "NO" )