I had a body of text in a string variable. I need to see if that variable contains a word found in column A, ‘Category’ - so if the word ‘ESAP’ is found, I create a folder of that name and end the activity. However if no word is found in Column A, I need to look in Column B ‘Category Keyword’. If a word is found there, I need to create a folder of the category name in Column A e.g if the word ‘IE Approval’ is found in Column B (Row 5), I would need to create a folder called ‘Payment cert’ (value from Column A). All the values in column B will be separated by a comma.
I think I can see how if a value is found in column A would work, I’m not sure how to deal with if a value is found in column B, how I would relate it back to the word in Column A
Any help would be really appreciated