Extracting text within parenthesis in a QGIS attribute table

المشرف العام

Administrator
طاقم الإدارة
I have a shapefile of data for Japan, and I need to extract the English character names in my "name" field in order to label the layer. Much of the data is all in Japanese, but some of the names have an alternate English name which can be found inside a set of parenthesis. I'd like to extract this text to another field and use it for labeling. I'm using QGIS.

Example:

I need to turn




أكثر...
 
أعلى