Hello, I upload to splunk a csv with list of names (only one column) and I wand to add additional names to the csv. how can I do that?  ... View more

I want to check in some strings are exist in a column and if they are I want to add another column with the type of the string I found inside. For example: The column - "Company" and inside we can found- google inc, amazon llc, Microsoft incorporation, university of china and more. The strings I wand to check- google, amazon, Microsoft. Important thing is that I have ~100 strings that I need to check if exist.  I want to add a column "company_Type" and if one of the strings exist in the column "Company" , it will write "Technology" and if not "other".  The result I want to get: Company Company_Type google inc Technology amazon llc Technology Microsoft incorporation Technology university of china other   ... View more