Filtering data from a column

satya04

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.

SP500_Geographic_Exposure_02192024.xls

Gawa

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.

1241957_gawa.yxmd