Hi,
I need to find in the sentence specific word and if this sentence contains this word create column "Country" with this word.
So for example: If text: "EMEA_EVG_GxP_UAT_TR_MD_Customer Setup" Contains "TR", Country should be TR.
In the excel field I created the column Country with the values which I should get using workflow.
I have as well the list of possible countries which we should have.
I've tried to create workflow but I'm getting to much findings.
Please find the attached sample and my workflow.
I will be grateful for support,
@Neffri something like this?