Code:
import delimited "http://qed.econ.queensu.ca/jae/datasets/ke001/readme.kh.txt", /// rowrange(45:75) clear delim(")") bindquote(strict) replace v2 =ustrregexra(v2,"\p{Z}","")
As current, my syntax here gets rid of leading spaces (and apparently the one for Inner Mongolia, but for now I can live with that). Optimally, I'd want all leading and trailing spaces gone. Equally, I've tried
Code:
import delimited "http://qed.econ.queensu.ca/jae/datasets/ke001/readme.kh.txt", /// rowrange(45:75) clear delim(")") bindquote(strict) replace v2 =strtrim(v2)
0 Response to Removing Leading and Trailing Spaces
Post a Comment