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

Learn more

View all

Sign in to view all badges

Classification Rule Builder: Force output to lowercase (RegEx)

Avatar

Avatar
Shape 100
Community Advisor
AndrewWathen
Community Advisor

Likes

582 likes

Total Posts

326 posts

Correct reply

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

Avatar
Shape 100
Community Advisor
AndrewWathen
Community Advisor

Likes

582 likes

Total Posts

326 posts

Correct reply

16 solutions
Top badges earned
Shape 100
Bedrock
Coach
Seeker
Springboard
View profile
AndrewWathen
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

153 likes

Total Posts

281 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

153 likes

Total Posts

281 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
Community Advisor
joshd7227840
Community Advisor

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
Community Advisor
joshd7227840
Community Advisor

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
joshd7227840
Community Advisor

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
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

351 likes

Total Posts

2,366 posts

Correct reply

822 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
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

351 likes

Total Posts

2,366 posts

Correct reply

822 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived