JCapper Message Board

JCapper 101
-- Adding a list of trainer names to a SQL UDM

Home	Register Log In

Adding a list of trainer names to a SQL UDM

jeff
10/29/2009
12:49:21 AM

From my email inbox...

--quote:

"Jeff,

My question is I want to add a list of Trainer names to a Sql udm and don't want to type each one out.

Any ideas getting them into a Sql udm without having to type them?

Thanks,

Bill"

--end quote

Hey Bill,

If you have a list of trainer names from another UDM or from the Name Selection Tool - Copy the names onto the Windows Clipboard and then Paste them inside of a SQL INSTR function as shown on the "Cheat Sheet"

Link to the SQL Cheat Sheet:
http://www.jcapper.com/HelpDocs/HelpFileSQL.txt

AND INSTR('PLETCHER TODD-MIYADI STEVEN', trainer) <> 0

Notice that there are single quote characters wrapped around the list of trainer names in the above line from a SQL Expression...

An easy way to do this would be to start with the following:

AND INSTR('XXXX', trainer) <> 0

And with the trainer names already sitting on the windows clipboard... highlight the XXXX characters inside of the single quote characters... but do not highlight the single quote characters themselves... and then just PASTE your list of trainer names over the highlighted XXXX characters...

Which results in the correct format ready to be saved as part of a SQL UDM Definition.

-jp

.

JCapper Message Board

JCapper 101 -- Adding a list of trainer names to a SQL UDM

JCapper 101
-- Adding a list of trainer names to a SQL UDM