Pick up of specific characters from cell

[SArielle]

Hi All, 

I am trying to perform a condition where if the column contains % then i want to pick up the XX.X%  or if the column contains a specific phrase then pick up 4-5 characters before that phrase in that column and put it in a new column. 

Is there a way to get that done? Any ideas will be great!

Thanks in advance!!

[SArielle]

I am parsing the any numbers before the phrase "bps" and in the parse output column type i did select "double" but when i put another formula behind to do a computation it tells me it is is still a string. 

[grazitti_sapna]

@SArielle, if you will apply the formula tool after the regex operation you can change the data type.

If you are trying to do any modification under the BPS column it will show double datatype as default.

Thanks!

[SArielle]

Seems like I'm hitting a roadblock. I was not able to see the dropdown that you shared, mine is all greyed out when i tried to put in a formula.

[grazitti_sapna]

@SArielle, this is because you are trying to apply a formula to the existing field, in order to be able to change the datatype of a field you need to create a new column.