|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Trainer Names | |
| tennoel 4/27/2012 7:16:35 PM | I'm trying to research trainers, and can't get O'Conner or O'Donnell to work. They show up using 'by trainer', but not in a SQL Udm. I've tried Odonnell without the apostrophe, still no luck. Suggestions? Thanks
| |
| jeff 4/27/2012 10:21:57 PM | If you are operating in SQL Mode you can use the LIKE command and a percentage sign "%" (without the quotes) as a wildcard character as a work around to get past the problems caused by that apostrophe character. Instead of keying on the entire CXN name, the LIKE command enables keying on the characters in the CXN name that come after the apostrophe character. Here's a link to a www3 Schools web tutorial: http://www.w3schools.com/SQl/sql_like.asp I'll use trainer Doug O'Neill to illustrate. HDW has his name as: O'NEILL DOUG F An HDW compatible way to use the LIKE command to key on the characters in the trainer field that come after the apostrophe character would be: AND TRAINER LIKE '%NEILL DOUG F' Brisnet has his name as: O'NEILL DOUG A Brisnet compatible way to use the LIKE command to key on the characters in the trainer field that come after the apostrophe character would be: AND TRAINER LIKE '%NEILL DOUG' Further info... If you have the latest program version, published 4/25/2012 or later, if the CXN Names Formatting setting in the Enhanced Settings Module is set to: 0 Remove Punctuation Characters the software will strip out commas, periods, and the single quote/apostrophe character from the names of riders, trainers, and owners when .JCP files are created. Earlier program versions running under the same setting are programmed to strip comma and period characters from CXN names - but not the single quote or apostrophe character. The behavior change in the latest program version for the CXN Names Formatting Setting doesn't edit existing data sitting already in .JCP files and already built pl_profile.txt files. (You would have to rebuild .JCP files and older databases from scratch in order to accomplish that task.) However, you can use the LIKE command to handle CXN names that have an apostrophe character as part of the name. -jp .
| |
| tennoel 4/28/2012 9:24:34 AM | That works. Tryin to figure that one out for awhile. Thanks Jeff.
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |