remove ;

[River Huang]

Dear All, I found this question here. The data is

* Example generated by -dataex-. For more info, type help dataex
clear
input float num str120 IPC
1 "B01D53/86(2006.01)I;B01D53/56(2006.01)I"                                         
2 "B01J23/30(2006.01)I;B01J35/10(2006.01)I;"                                        
3 "B01J23/92(2006.01)I;B01J23/30(2006.01)I;B01J38/02(2006.01)I;B01J38/04(2006.01)I;"
end

If IPC ends with ";" (num=2,3), how can I delete it? Thanks.

[Rich Goldstein]

try this:

gen leng=length(IPC)
replace IPC=substr(IPC,1,leng-1) if substr(IPC,-1,1)==";"
drop leng

[Leonardo Guizzetti]

An alternative method:

gen want = ustrregexrf(IPC, "^(.*);$", "$1")

[River Huang]

Dear @Rich Goldstein and @Leonardo Guizzetti, Thanks a lot for your helpful syggestions.

[William Lisowski]

Also

replace IPC = ustrregexrf(IPC, ";$", "")

[River Huang]

Dear @Rich Goldstein, @Leonardo Guizzetti, and @William Lisowski: Thanks a lot for your helpful suggestions.

[River Huang]

Thanks a lot, William.