Dear all,
I need to clean up one variables in a dataset.
e.g. lets say the dataset is "trial", the variable for cleaning up is "V1"
>trial$V1
[1] 0(a=1)   0(b=1)  0.133(b=1)   0.555(a=1)  >5.32(a=1)
what i need to do is to remove the text (a=1) and (b=1) and the ">" in the
V1, and then convert to a numeric variable, and als I am aslo requested that
when the value has a=1, the value needs to be divided by 5.
what I did is:
trialchara<-as.character(trial$V1)
trialnum<-gsub("(a=1)|(b=1)|>","",trialchara)
the result is
[1] "0 ()" "0 ()" "0.133 ()" "0.555 ()" "5.32 ()"
How can I get rid of the () symbol?
How can I do this part "when the value has a=1, the value needs to be
divided by 5." ?
Can anyone please give me some hints here?
Thanks a lot.
John

	[[alternative HTML version deleted]]


