This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You can make a text input with the following data in 1 column named "Search":
Create a record ID of your dataset (going to call it "Text" here and I'm assuming you have lots of text data in separate rows).
Append the "Search" text input to your dataset so that each row of "Text" data is duplicated 4x, 1 for each "Search" issue type.
Then make a formula like this in a new column called "FindString": FindString([Text],[Search])
This will spit out a value if if finds one of your search parameters (Install, Configure, Error or Crashing) in your "Text" data row. If it doesn't find one of those words then it will return -1 otherwise it will return the value where the string was found in the text.
You can filter out all -1 values.
Since you appended the "Search" data to your original "Text" data, you should be able to tell what type of issue was flagged. You can group/summarize your data to show you this information as needed.
You can use find/replace tool to identify the word in the column and then assign that key word the column if you use an input that is just a list of the four words. If you click open example under Find and Replace tool and then go down to the "Append Column (Instead of Replace)" I think that is what you need.