Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

Find more posts tagged with

AI Studio

Accepted answers

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

All comments

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