extract only string

[umairah]

I know this a common question but I need help to extract only the country name as below.

Thank you for the help,

Regards 

Umairah

[BrandonB]

Could you use a data cleansing tool where you check the boxes to remove numbers and punctuation?

 

[grazitti_sapna]

Hi @umairah , try this.

Thanks.

[umairah]

Hi @BrandonB ,

Hi @grazitti_sapna ,

Sorry my question maybe not detailed enough I want to extract only the country name by using regex but I can't seem to take certain name because of the space and special charatcers that included.I will attached the sample data for your reference.

[grazitti_sapna]

Hi @umairah ,try this.

Thanks.

[vizAlter · Accepted solution]

Hi @umairah —Hope attached the solution will be helpful:

.

Use this expression in the Custom Filter tool:

REGEX_CountMatches([Data], "\s([0-9].)")

Use below expression in the RegEx tool (for Replace in Output Method):

\s([0-9]{1,3}.)+

If this solves your issue please mark the answer as "Solved" with a Like, if not let me know!