How to perform character-based replacement between two variables

[jimmy chen]

Hi everyone, I would like to ask a question about character-based replacement. We can use command "subinstr" to replace a fixed string "s1" in variable A with a fixed string "s2", just like

replace A=subinstr(A,"s1","s2",.)

But how can i replace the changed string but the same as variable regionname in variable firmname with string with brackets added. The example data is following. For example, replace the string "Samsung Electro Shenzhen" with "Samsung Electro (Shenzhen)" in line 2.

 
firmname
regionname

Samsung Electro Shenzhen
Shenzhen

Fluid Control Equipment Xiamen Co., Ltd.
Xiamen

Sanyao Electronics Insulation Shenzhen Co., Ltd.
Shenzhen

Sanyo Chemical Shanghai Trading Co., Ltd.
Shanghai

Sanrui Jixiang Technology Shenzhen Co., Ltd.
Shenzhen

Sanmei Garment Shenzhen Co., Ltd.
Shenzhen

Sanlian Plastic Shenzhen Co., Ltd.
Shenzhen

Sanhua Yaveko Electrical Equipment Wuhu Co., Ltd.
Wuhu

Mitsubishi Chemical Polyester Film Suzhou Co., Ltd.
Suzhou

MUFG Bank China Co., Ltd. Chengdu Branch
Chengdu

Power Semiconductor Hefei Co., Ltd.
Hefei

Triangle Weihai Huajin Electromechanical Equipment Co., Ltd.
Weihai

Sanno Machinery Dalian Co., Ltd.
Dalian

Sanbang Packaging Materials Shenzhen Co., Ltd.
Shenzhen

Sanmenxia Suda Transportation Energy
Sanmenxia

Sanjun Technology Shenzhen Co., Ltd.
Shenzhen

Sanhong Automation Technology Guangzhou Co., Ltd.
Guangzhou

Sanhuang Fashion Shenzhen Co., Ltd.
Shenzhen

Sanhuang Fashion Shenzhen Co., Ltd. Chongqing Yuzhong Branch
Yuzhong

Sanlong Huizhou Chemical Fiber Co., Ltd.
Huizhou

Shangli Weichuang Dalian Machinery Co., Ltd.
Dalian

Shanghua Property Management Shenzhen Co., Ltd.
Shenzhen

Shangyuan Investment Shanghai Co., Ltd.
Shanghai

Shangshi Environmental Protection Yiyang East New District Sewage Treatment Co., Ltd.
Yiyang

Shangxing Jixiang Technology Shenzhen Co., Ltd.
Shenzhen

Shanghai Mining Explosion
Shanghai

Shanghai Jiufeng Agricultural Machinery Factory
Shanghai

Shangyi Craft Products Factory Shenzhen Co., Ltd.
Shenzhen

Shanghai Pharmaceuticals Holdings Yantai Co., Ltd.
Yantai

Shanghai Pharmaceuticals Qingpu Medical Health Services Shanghai Co., Ltd.
Qingpu

Shangye Leather Goods Shenzhen Co., Ltd.
Shenzhen

Shangming Transformer Shenzhen Co., Ltd.
Shenzhen

Shangrao Daxinyi Packaging Co., Ltd.
Shangrao

Shangrao Water Conservancy Research Institute
Shangrao

Shimomura Cutlery Shenzhen Co., Ltd.
Shenzhen

Perfetti Van Melle Confectionery China Co., Ltd. Shenzhen Branch
Shenzhen

Shiyi Laser Equipment Hangzhou Co., Ltd.
Hangzhou

Shiyade Mechanical Engineering Hangzhou Co., Ltd.
Hangzhou

Shihua Zhaoqing Trade Co., Ltd.
Zhaoqing

Shifasheng Trade Xiamen Co., Ltd.
Xiamen

Thanks very much

[George Ford]

you want to replace the regionname in firmname with "(regionname)"?

[Nick Cox]

gen wanted = subinstr(firmname, regionname, "(" + regionname + ")", 1)

[jimmy chen]

you want to replace the regionname in firmname with "(regionname)"?

Hi George, I do want to replace the regionname in firmname with "(regionname)" and Nick's answer can solve this question. Thank you!

[jimmy chen]

gen wanted = subinstr(firmname, regionname, "(" + regionname + ")", 1)

Thank you, I misunderstood this command. "subinstr" can work fine.

[Nick Cox]

Good that you solved your problem! Note that subinstr() is a function, not a command.

[jimmy chen]

Good that you solved your problem! Note that subinstr() is a function, not a command.

Thanks, I get it