Dear All, How can I use regular expression to separate the following data
Code:
clear
input float subject_ID str19 SexAge_Race
1 "MALE41.2_WHITE"  
2 "FEMALE42_BLACK"
end
into
Code:
clear
input float subject_ID str10 Sex float Age str10 Race
1 "MALE"   41.2 "WHITE"
2 "FEMALE"   42 "BLACK"
end
Thanks.