classification builder

[scottt23929401]

I have two different types of values and I want to classify them into quartile buckets for scroll depth tracking.

value 1 = highestPercentViewed = 33 | initialPercentViewed = 33

value 2 = 33|33

the above should both be bucketed in 50% scroll depth

however I cannot do both in the same logic. is there a way to get both in the same logic?

highestPercentViewed = ([1-9]|1[0-9]|2[0-5])(?:[^0-9]|$) = up to 25%

highestPercentViewed = (2[6-9]|3[0-9]|4[0-9]|50) = up to 50%

highestPercentViewed = (5[1-9]|6[0-9]|7[0-5]) = up to 75%

highestPercentViewed = (7[6-9]|8[0-9]|9[0-9]|100) = up to 100%

[fsakjlfdsakljfd]

Have you considered uploading a classification file instead?  I did something similar with a client in the past and it took less than 10 minutes to complete with excel.

[Asheesh_Pandey · Accepted solution]

You can use following, it should match both the conditions.

((^.*\b0?[0-9]$|.+1[0-9]|.+2[0-5])) = up to 25%

((.+2[6-9])|.+3[0-9]|.+4[0-9]|.+50) = up to 50%

((.+5[1-9])|.+6[0-9]|.+7[0-5]) = up to 75%

((.+7[5-9])|.+8[0-9]|.+9[1-9]|.+100) = up to 100%

Thanks,

Asheesh

[scottt23929401]

perfect. thanks. this will help me improve my regex skills