Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Classification Rule Builder: Force output to lowercase (RegEx)

Avatar

Avatar
Shape 100
Community Advisor
Andrew_Wathen_
Community Advisor

Likes

592 likes

Total Posts

328 posts

Correct reply

16 solutions
Top badges earned
Shape 100
Bedrock
Coach
Seeker
Contributor 2
View profile

Avatar
Shape 100
Community Advisor
Andrew_Wathen_
Community Advisor

Likes

592 likes

Total Posts

328 posts

Correct reply

16 solutions
Top badges earned
Shape 100
Bedrock
Coach
Seeker
Contributor 2
View profile
Andrew_Wathen_
Community Advisor

13-10-2016

Some versions of Regex include a "\L" syntax that allows a string to be forced to lowercase.

 

This would be really useful as at the moment the classification that is created reflects the case of the original input - which can lead to messy looking values in reports.

 

For example...

 

Input value:

website.com/PROMotion

 

RegEx:

^(.+)(\/.+)$

 

Mapping rule:

$2

 

Results in:

"/PROMotion" appearing in the report, where as I would prefer "/promotion" to appear in the report

 

Note: this is about the output, not the matching criteria - aware we can already do case insensitive matching

3 Comments

Avatar

Avatar
Establish
Employee
ericmatisoff
Employee

Likes

156 likes

Total Posts

287 posts

Correct reply

79 solutions
Top badges earned
Establish
Give Back 200
Give Back 100
Give Back 50
Coach
View profile

Avatar
Establish
Employee
ericmatisoff
Employee

Likes

156 likes

Total Posts

287 posts

Correct reply

79 solutions
Top badges earned
Establish
Give Back 200
Give Back 100
Give Back 50
Coach
View profile
ericmatisoff
Employee

14-10-2016

I love this idea. Great suggestion @AndyW 

Avatar

Avatar
Ignite 3
Level 9
Josh_Du
Level 9

Likes

275 likes

Total Posts

241 posts

Correct reply

70 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Ignite 3
Level 9
Josh_Du
Level 9

Likes

275 likes

Total Posts

241 posts

Correct reply

70 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 100
Give Back 50
Give Back 25
View profile
Josh_Du
Level 9

21-10-2016

@AndyW - Actually no, we cannot do case-insenstive matching.  CRB is case-sensitive. 

 

A couple years ago when CRB first came out, the regex tester popup (where you enter in the regex and a single key to test against) was case-insensitive.  But when you go to the rule tester (where you enter in multiple keys to show classification results), that was case-sensitive.  And if you actually run the rule, the actual process is also case-sensitive.  

 

This was a bug I reported to Adobe when it first came out.  I asked them if they could either make a flag to specify case-senstivity, or failing that, make everything case-insensitive. Their reponse was to make everything case-sensitive.  Which really sucked.  Because now I have to do dumb workarounds for values like this: ^[Ff][Oo][Rr][Mm]$

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

359 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

359 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived