🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Extract exact number

User: "abbaszavar"
New Altair Community Member
Updated by Jocelyn

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

Sort by:
1 - 1 of 11
    User: "sgenzer"
    Altair Employee
    Accepted Answer

    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