|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Help with bat file | |
| mikejlb 5/24/2009 3:47:21 AM | I've been away from writing programs since gwbasic and dbase4 so I am way beyond the rusty stage. I should know how to write a simple bat file but I'm stuck on using some key strokes. What I would like to do is copy a list of trainer or jockey names from excel and paste them to notepad. In notepad I would have a column of names that I'd like to paste into the check trainer/jockey box. What I have been doing to edit this list is use 3 keys, - Del End. Repeating the 3 keys until the blank spaces are removed and a - is inserted between the names will give me a list that can be copied and pasted into the JC program. A batch file that would repeat the 3 key strokes about 20 times and work with the notepad file would save a lot of time and work. I can't find a keyboard reference to Del a single space that would pull the next name up to the minus sign. I can't find End key either. Is this idea workable? A website for keyboard strokes would be helpfull too. Any suggestions would be appreciated. ~Edited by: mikejlb on: 5/24/2009 at: 3:47:21 AM~
| |
| ryesteve 5/24/2009 10:31:20 AM | Instead of doing it that way, if the list of names is already in Excel, why not just format it there? For instance, if your trainer names are in Column A, make a formula that looks like: +A1&"-"&+A2&"-"&+A3 etc, and you'll have all the trainer names in one line separated by a hyphen, which is what I think you're looking for.
| |
| mikejlb 5/24/2009 6:03:09 PM | Steve, your idea looks like a good answer. I'm testing now with 20 records at a time. Thanks for the response. ...mike I tried to do 100 names and it only copied 67 names. It does handle 50 names ok and that's enough. This will save me a lot of time. Thanks again for the help, Steve. ~Edited by: mikejlb on: 5/24/2009 at: 6:03:09 PM~
| |
| ryesteve 5/24/2009 11:15:20 PM | Happy to help...
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |