Hello!! I would need guidance on the following concern.
I have data by geographic segment in column G. I have country names and segment share mentioned in %. I would need to find the % share of China and Greater China wherever it is mentioned. There are 32 such instances in this file. I am expecting column J to update only the percentage against China or Greater China for those cases where it is mentioned.
I have attached the file here for your reference. Please take a look and kindly guide me on designing the workflow.
hi @satya04
You can parse data by Text to Column tool, and Regex tool to find out the percentage% of the target segment(country).
*As I could not column G properly, I copy&paste it to Text tool.