Hi Throttle Works,
I have uploaded the sample file.
Columns
Summary Description Alert Name Tool Effected
My Requirement is
One
First column i want to update is the Tool Column. The Condition is IF A1 starts with "Infrastructure" then the Tool might be Net or SCO else it is "Manual", but to determine whether it is Net or SCO then the formula should also check in the Column "Effected" it has to search the cell if it contains the text "NIQ" If it contains NIQ then display "NIQ", then it has to search in the cell for text "SCO", if it contains SCO then display "SCO", else display Manual..
Problem with searching for text SCO in the cell, there will be even names in the cells if there is Scott Styris in the cell then it contains "SCO", so the formula should only search for the text in the cell starting with "SCO" or "NIQ"
Two
Now i want to update the Alert Name column. If D1=NIQ, then it calculate the formula "=MID(A2,FIND("KS_Name=",A2),((FIND(";JobID",A2)-FIND("KS_Name=",A2))))" [I will explain this after this], if it D1=SCO then it should just pull the text from Description column and display that {Ex: Display B5}, if the cell contains Manual then it should display just "Manual".
Explanation for the above mentioned MID Formula.
Summary Column is an Auto Generated text, so has lot of charecters. But there is also a pattern in all the alerts for which the Tool is "NIQ" so if the Tool is NIQ then it should pull from the certain pattern from the cell in Summary Column. The example is shown in A1, A2, A3. The Pattern is i want KS_Name=xxxxxxx_xxxx;JobID=234516;EventID. From this i want only --> KS_Name=xxxxxxxx;<--JobID. I want only the text till ";" before the "JobID" i.e., ";JobID" starting from KS.
Please solve this problem
Sample file attached.