Column Parse for string

[archanacg1]

I need to parse the columns for specific string like (APPLE|Dell) and if found i want to output which column i found it in separate column as source column.

In the output next to Computer column i would like to get new column(Source column) where i need to populate where the string is found like in ( summary ,description or technical summary)

Input---

Output--

[FinnCharlton]

Hi @archanacg1 , this workflow will do that for you:

[BS_THE_ANALYST]

@archanacg1 one way:

[archanacg1]

This is completely emiminating if computer(search string is not found). Even if there is no computer in the input i want the record in output with null value

[archanacg1]

This is completely filtering computer(search string is not found). Even if there is no computer in the input i want the record in output with null value

[BS_THE_ANALYST]

@archanacg1 okay, this should be fine.

By the way, if you want to search for more terms like Dell, Apple, etc, just add them to the lookup table :-) 

[BS_THE_ANALYST]

@archanacg1 it just returns empty (null) if nothing is found:

[archanacg1]

Hi,

I am looking for this column where the source is from..it should display all records even if there is computer null.

[binuacs]

@archanacg1 Something like this?