I hope you are staying safe.
I have data set with code and name like this.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str12 code str36 name "160610117117" "A" "160610118118" "B" "160615001003" "C" "160615001015" "D" "160615001026" "E" "160615001031" "F" "160615001094" "G" "160615001103" "H" "160615001114" "I" end
160610117117 -> 16061117
So, I want to reformulate the codes with first five and last three parts.
I tried some codes with substr() but could not figure out.. By the way, the codes are string variable! If you think changing to numeric is better let me konw!
0 Response to Extracting first five and last three parts from string variable.
Post a Comment