Filtering names with special characters

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Filtering names with special characters

Postby bdwoland » Sat Jun 20, 2020 3:56 am

Hi everyone!

I'd like to filter OUT players in a database, using an expression filter. There are 2 players with special characters in their name: one with an ' and one with an Á (hungarian character).
Because of these characters, the following expression filter does not work:

NOT (player.player_name ='playerÁ' OR player.player_name ='le'bouc')

Is there any way to somehow exclude these players from my all player reports?
Thank you very much,
yours sincerely,
Daniel
bdwoland
 
Posts: 14
Joined: Fri Sep 11, 2015 1:20 pm

Re: Filtering names with special characters

Postby Flag_Hippo » Sat Jun 20, 2020 6:07 am

That's a known issue and you can open a Support Ticket to be linked to that and get notified when it's fixed. The only alternative I can suggest is using _ as a wildcard to substitute for the special characters e.g:

NOT (player.player_name LIKE 'player_' OR player.player_name LIKE 'le_bouc')
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Filtering names with special characters

Postby BillGatesIII » Sat Jun 20, 2020 3:10 pm

    I guess you can use dollar quoting.

    Code: Select all
    player.player_name not in ($$playerÁ$$, $$le'bouc$$)
    BillGatesIII
     
    Posts: 740
    Joined: Fri Dec 16, 2011 6:50 pm


    Return to PokerTracker 4

    Who is online

    Users browsing this forum: No registered users and 51 guests

    cron
    highfalutin