Players with punctuation in their name.

[John Currey]

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

https://s3.sportsdatabase.com/NBA/query.html?sdql=Player%3Alist%3Aname%40team%3DSeventysixers+and+%27Joel+Embiid%27+not+in+Player%3Alist%3Aname+and+season%3D2022+&submit=++S+D+Q+L+%21++

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

https://s3.sportsdatabase.com/NBA/query.html?sdql=Player%3AJames+Harden%3Arebounds%40team%3DSeventysixers+and+%27Joel+Embiid%27+not+in+Player%3Alist%3Aname+and+season%3D2022+&submit=++S+D+Q+L+%21++

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

 

https://s3.sportsdatabase.com/NBA/query.html?sdql=Player%3AP.J.+Tucker%3Arebounds%40team%3DSeventysixers+and+%27Joel+Embiid%27+not+in+Player%3Alist%3Aname+and+season%3D2022+&submit=++S+D+Q+L+%21++

Thanks. 

[Joe Meyer]

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

https://s3.sportsdatabase.com/NBA/query.html?sdql=Player%3Aquery%28rebounds%40name%3D%27P.J.+Tucker%27%29%40team%3DSeventysixers+and+%27Joel+Embiid%27+not+in+Player%3Alist%3Aname+and+season%3D2022+&submit=++S+D+Q+L+%21++

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]

OK, removing the special characters from the data is the best approach. I'll do that. Thanks.