Players with punctuation in their name.

20 views
Skip to first unread message

John Currey

unread,
Jan 2, 2023, 5:21:48 PM1/2/23
to SDQL API
This shows who played for the Sixers when Joel Embiid did not play:

Player:list:name@team=Seventysixers and 'Joel Embiid' not in Player:list:name and season=2022


As you can see,  "De'Anthony Melton" and  'P.J. Tucker' have non-letters in their names.

This works for James Harden but fails for players with non-letters in their names.

Player:James Harden:rebounds@team=Seventysixers and 'Joel Embiid' not in Player:list:name and season=2022


Player:P.J. Tucker:rebounds@team=Seventysixers and 'Joel Embiid' not in Player:list:name and season=2022 
 

Thanks. 

Joe Meyer

unread,
Jan 2, 2023, 7:04:24 PM1/2/23
to sdq...@googlegroups.com
John and SDQL API Friends,

to take full advantage of SDQL's CamelCaseCompletion of player names, remove special characters before uploading.

Otherwise, you can use the Player query method, like this:

Player:query(rebounds@name='P.J. Tucker')@team=Seventysixers and 'Joel Embiid' not in Player:list:name and season=2022


Best regards,

Joe Meyer
Sports Database LLC
 

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/5c36a47f-a18a-4d2e-98ac-3173d53914a9n%40googlegroups.com.

John Currey

unread,
Jan 3, 2023, 3:55:20 PM1/3/23
to SDQL API
OK, removing the special characters from the data is the best approach. I'll do that. Thanks. 
Reply all
Reply to author
Forward
0 new messages