Hey All! I have a character variable of varying lengths that I want to separate into separate variables. The variable always follows the following pattern - AA.AA.AA.AA.AA (2 characters then a period, 2 characters then a period, etc) - and each "AA" signifies a unique code I need to have separated for further analysis. Example of what it looks like now: orig_var AA.4F.9U.EB E5.U9 GB.D2.4F.EB.AA.M2 T4 YY.4D.U9 How I'd like for it to look: orig_var new_var1 new_var2 new_var3 new_var4 new_var5 new_var6 AA.4F.9U.EB AA 4F 9U EB . . E5.U9 . . . . GB.D2.4F.EB.AA.M2 GB D2 4F EB AA M2 T4 T4 . . . . . YY.4D.U9 YY 4D U9 . . . Any thoughts on how to code this to parse those 2-char codes? Thanks! Erice
... View more