Pick up of specific characters from cell

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!!

Parse

Accepted answers

grazitti_sapna

@SArielle , I used the below regex. As $ is represented as the end of the line in Alteryx so I skipped this character and used a formula tool to replace the $ with ""

(\d.+%|\$\d.+)

Attached is the updated workflow.

Thanks!

SArielle_Workflow.yxmd

All comments

ddiesel

Hi @SArielle!

Will something like this work?

If not, will you please send over some dummy data and the desired output?

Thanks,
Deb

Pick up of specific characters from cell_dmd.yxmd

Qiu

@SArielle
Try RegEx if you like it. 😁

@ddiesel
Thank you for the input data.

Pick up of specific characters from cell_dmd-r1.yxmd

SArielle

Let me try your suggestion out but let me also share some dummy data that is similar to what I have.

This is the data

Customer	Desc 1	Desc 2	Comment 1	Comment 2
A	Discount given is 10%	Approval pending	Last purchase 30% discount given
B	Approval given by Director	Discount given is 25%	First discount
C	Quoted 15% above base price	Customer requested loyalty discount	Discount given is 5.5%	Approval given by Director

and the desired output would be having an additional column that captures the discount

Customer	Discount
A	10%
B	25%
C	5.5%

SArielle

Thanks Sapna, just a quick question if my numerics is not a % instead it is a $ in front of the numeric or if it is a specific phrase after the numerics how can i amend the regex format to achieve the same results you have?

grazitti_sapna

@SArielle , I used the below regex. As $ is represented as the end of the line in Alteryx so I skipped this character and used a formula tool to replace the $ with ""

(\d.+%|\$\d.+)

Attached is the updated workflow.

Thanks!

SArielle_Workflow.yxmd

ddiesel

Hi @SArielle!

Did @grazitti_sapna's solution work for you? If so, kindly select it as the solution. Marking a solution helps other users facing similar issues.

SArielle

Thank you everyone!!! Really appreciate all the support on this!

@grazitti_sapna your solution was really great, it helped me to parsed out a lot of the data but still some minor errors.

I also have an additional question, might be quite basic but does all the output from Regex auto becomes string despite choosing in the output columns as a double?

grazitti_sapna

@SArielle, as you are parsing the data in form like 10%, 35% so this can only result in string data type in case you just parse the digits then you can select the double data type.

Thanks!

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703