Filter a field using character mask

[renatomitsunami]

Hi..I'm trying to use a mask filter in a field, like this example:

Name	Ticket
John	123456/2017
Mary	564587/2017
Anthony	698/2017
Peter	1356/201

After apply mask filter in "Ticket" field, the expected result is:

Name	Ticket
John	123456/2017
Mary	564587/2017

Ticket field with "######/####" format.

How can I apply this filter ?

Thanks.

[MiditecReportDev]

You could try it with using a PrintWhen-Expression on the field, using $F{Ticket}.length == 6 if the first part of the value in your text field is $F{Ticket}. Then if the second part is some other field just use "$F{Ticket}.length == 6 && $F{OtherField}.length == 4"

[MiditecReportDev]

You could try it with using a PrintWhen-Expression on the field, using $F{Ticket}.length == 6 if the first part of the value in your text field is $F{Ticket}. Then if the second part is some other field just use "$F{Ticket}.length == 6 && $F{OtherField}.length == 4"

[renatomitsunami]

Hi PEichelberg,

I need to count the numbers of occurences in correct pattern format "XXXXXX/XXXX" = (6 characters before "/" and 4 characters after "/")

>>  IF $F{Ticket} contains a string with correct format THEN 1....Else 0.

In this example, 2 corrects rows:

Name	Ticket
John	123456/2017
Mary	564587/2017

 

Thanks again

[renatomitsunami]

Hi PEichelberg,

I need to count the numbers of occurences in correct pattern format "XXXXXX/XXXX" = (6 characters before "/" and 4 characters after "/")

>>  IF $F{Ticket} contains a string with correct format THEN 1....Else 0.

In this example, 2 corrects rows:

Name	Ticket
John	123456/2017
Mary	564587/2017

 

Thanks again

[MiditecReportDev]

Okay ... so basically you want to only display those $F{Ticket} that match your format of ######/#### and hide every other one ...

 

So what you need to do is get your data as usual but then in the Dataset and Query Dialog go to tab Filter Expression.

 

Put $F{Ticket}.matches(REGEX) == true there. Or == false. I'm currently not sure which one would help actually :D

 

REGEX should be a String pattern like this: d{6}/d{4}

 

You can check the meaning of this at https://regex101.com/ as I did too. Basically that regex checks if you've got a string that has six digits, a slash and four further digits. If so, the regex says your string is valid. As I said, I don't know if you need to say == true or == false in FilterExpression, but you can figure that out easily.