Extract exact number

abbaszavar

Hi there 

 

I have an excel file in one column and each row include health information regarding a patient.

How can I extract the amount of blood pressure in each row?

Example: bp = 120 (how can I extract 120 in a seperate column in the output?)

 

Please advise.

 

Thanks,

Abbas

 

sgenzer

hello @abbaszavar - it is good to have you here.  I would use Generate Attributes (best operator in RapidMiner IMHO) and do something like this if your column is labeled att1:

 

bloodPressure                 parse(suffix(att1, length(att1) - index(att1,"=") - 2))

 

Scott

 

sgenzer

hello @abbaszavar - it is good to have you here.  I would use Generate Attributes (best operator in RapidMiner IMHO) and do something like this if your column is labeled att1:

 

bloodPressure                 parse(suffix(att1, length(att1) - index(att1,"=") - 2))

 

Scott

 

abbaszavar

Hi Scott,

 

Thanks for your reply.

It is just works if my variable was in the end of the line. Actually sometimes I have the same variable and its amount in the beginning or middle the line.

Could you please let me know how I can modify algorithm to can cover all possibilities?

 

Thanks in advance,

Abbas

sgenzer

hello @abbaszavar - in that case you should probably use a RegEx expression and slice+dice from there.  

 

Scott