Registering and logging in removes this ad.
Registering and logging in removes this ad.
How Do I Get Rid of That Annoying Space in MS SR???
Submitted by phenning on Mon, 08/14/2006 - 20:26.
Hi!
It seems like there are some pretty darned smart folks in this
group. So, all you smartie-pants people, here is your challenge:
I'm using MS SR with both Word 2003 and Excel 2003. How the heck do
you control/alter the spacing with MS SR??? In my particular case, I
want to set it so that it does NOT add a space after a word (I want
to use it for keywording images in Excel). I've combed through the
MS Help section and, of course, there's not a thing there that would
be helpful on this subject!
I could REALLY use your help on this. I have found MS SR to be
amazingly good (I was doubtful going in: it's from Microsoft, after
all, and it's "free" with the programs, so how good could it be,
right?). I have already experimented with it in the keywording
process and like the results, but for formatting reasons I cannot
have a space after each word...NO GOOD!
I hope one of you Einsteins can enlighten me on this...THANKS!!!
All the best,
Paul H H
phenning wrote: : I'm using
:
I'm using MS SR with both Word 2003 and Excel 2003. How the heck do
you control/alter the spacing with MS SR??? In my particular case, I
want to set it so that it does NOT add a space after a word
In Dragon the command is "No space." Worth a try.
Martin
I'm thinking of giving
I'm thinking of giving Dragon a try, so thanks for this. I'll try it with MS, too. But, is this a command that you have to say every time you enter a word? I am looking for a "universal setting" which will prevent the program from placing a space after EVERY word.
In NaturallySpeaking, say
In NaturallySpeaking, say "no space on"; the program will then stop putting spaces after words till you say "no space off"
Judy
Now THAT is cool. So, the
Now THAT is cool. So, the big question: does anybody know if Microsoft SR has any similar capability/command???
Same in ViaVoice. Quentin
Same in ViaVoice.
Quentin
I thought but did not say
I thought but did not say when you asked the same question at ms-speech.com:
I not sure what "keywording images in Excel" entails, but if you explained a bit more about what you're doing it would increase the chances someone might figure out a way to achieve your goal.
Bruce
Well, I didn't want to give
Well, I didn't want to give too much info, since it's actually pretty boring and I didn't want to put everyone to sleep. But, since you asked: I have an outsourcing service for professional photographers and picture libraries. These collections of images could be as small as several hundred or as large as hundreds of thousands. How do you find the "right" image in such databases? By entering keywords into a search box. But first, those keywords must be attached to the image. When the "search" keyword matches up with a keyword attached to an image, it appears in the subsequent "search results." The keywords are descriptors. For example: if it's an image of a man in an office using a computer, keywords we might assign to that image would include: man, male, middle aged, office, business, work, indoor, executive, computer, business, etc. The way we currently do it, all of the keywords are entered into vertical columns in Excel. Each column contains the keywords for a single image.
Due to the way we have to format the keywords in final form (and I won't go into detail here about that, because that really IS boring!), we cannot have a blank space after each word. Unfortunately, MS SR automatically enters a space after each word that you dictate. That's fine if you're working on most types of text, such as a letter, memo or the great American novel. For us, though, it's no good, and what I'm hoping someone can tell me is whether it is possible to customize the program so that it will not do that.
Hope that helps..
Well, not from me -- at
Well, not from me -- at least not on the details of MS-SR. But here is the kind of alternate work-around I was thinking of:
Create a macro in Excel that replaces blanks with no spaces. Put this macro on a button and click it when needed.
There may well be better ways of getting what you need -- hoping someone can help you out.
Bruce
I don't know anything about
I don't know anything about MS Speech -- there's a yahoo group called ms-speech that might be able to help
Judy
Thanks for the suggestion,
Thanks for the suggestion, but I've been a member of that group already. It's just a bunch of folks who like to sit around and nitpick over every detail of the upcoming MS Vista program. B-O-R-I-N-G! It sounds like there are a bunch of smart folks in that group, and yet not a one of them has been able to answer my question about controlling spacing with MS SR. So, I finally just quit the group, since they weren't helpful at all. I've only been in this group for a couple of days and have already had more assistance than I received in several months with the other group! My thanks to all of you for responding. I think that's what groups like this are for, right? Sharing information and helping those in need of advice and knowledge.
"Thanks for the suggestion,
"Thanks for the suggestion, but I've been a member of that group already."
Oh sorry. Then I just don't know what to suggest (using MS SR, that is)
Judy
The moderator of that group
The moderator of that group has posted some documents showing what commands are available in MS Speech. I don't remember any commands on spacing, but I don't regularly use MS speech. You might read join the group and look at those documents.
Thanks, I do have that list,
Thanks, I do have that list, but didn't see anything on there that seemed relevant. Maybe I missed it, though...will look again.
Hi Paul, Unfortunately,
Hi Paul,
Unfortunately, there really isn't a way to do this automatically with Microsoft's SR included with Office XP and 2003. In fact, we dont' have a way to do that with Windows Speech Recognition in Vista either, although, I'll certainly add that to the list of improvements we should make in future versions though.
However, for your specific situation one of the previous posts suggested writing a macro inside Excel itself that would take care of this issue for you. For example, you could write a macro that would iterate over all the cells in a certain range, and for all the cells that contain text, you could strip off the trailing spaces, and you could even activate this macro on the Saving event from the Excel object model.
Have you ever written an Excel macro before?
--
Rob Chambers [MSFT]
http://blogs.msdn.com/robch/default.aspx
Architect - Windows Speech Recognition - We're Listening...
This posting is provided "AS IS" with no warranties, and confers no
rights.
Hello, Rob... And thank
Hello, Rob...
And thank you...NOW we're getting some place. You're right, this IS a feature you should build into the next release; apparently ViaVoice and Dragon already have it.
The macro solution sounds like it would work, though I have NOT written a macro before. Can I assume that I do not need a Ph.D. in computing in order to do it???
phh
Yeah, hopefully one wouldn't
Yeah, hopefully one wouldn't have to have a Ph. D.
This took a little longer than I'd hoped. My VBA skills are quite rusty compared to my C++ and Windows programming skills. But ... 15 minutes later, I have the solution for you:
Paste this macro into your Excel spreadsheet in the VBA project under ThisWorkbook (to get there, open Excel, press Alt-F11, and then click on the "ThisWorkbook" item in the project hierarchy):
---- start here, but don't include this line
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
startCol = 2
stopCol = 3
startRow = 1
stopRow = 10
For c = startCol To stopCol
For r = startRow To stopRow
Addr$ = Chr$(65 + c - 1) + LTrim(Str$(r))
newVal$ = LTrim(RTrim(Range(Addr$).Value))
Range(Addr$).Value = newVal$
Next r
Next c
End Sub
---- stop here, but don't include this line
Here's what the macro does:
1.) Initializes some local variables to say what cells in the work book will be modified (in my example, I start at column 2, and go up to column 3, and I start at row 1 and go up to row 10 (thus modifying a block from B1 thru C10)).
2.) Loops over the columns and rows with the VB for statements
3.) Construct the address of the cell based on it's row and column (there might be a more elegant way to do this, but what I have here does work ... at least up to column Z)
4.) Prepare the new value by trimming off the right and left spaces
5.) Sets the new value back on the cell
That's it. I tested it briefly so hopefully you can use this as a starting point for your macro.
--
Rob Chambers [MSFT]
http://blogs.msdn.com/robch/default.aspx
Architect - Windows Speech Recognition - We're Listening...
This posting is provided "AS IS" with no warranties, and confers no
rights.
Wow! Of course, I could have
Wow! Of course, I could have figured that out, too...if I spent about a WEEK doing nothing else!!! THANK YOU...it's quite late, and I'm in Chicago most of tomorrow, but I'm looking forward to trying this out on Friday when I'm back in the office and awake! I'll let you know how it works for me.
phh
No problem. Glad to help
No problem. Glad to help out... Now only if we had had that feature that you really wanted in the software. Maybe next release.
--
Rob Chambers [MSFT]
http://blogs.msdn.com/robch/default.aspx
Architect - Windows Speech Recognition - We're Listening...
This posting is provided "AS IS" with no warranties, and confers no
rights.
Full marks to Rob. It shows
Full marks to Rob. It shows how Microsoft is listening to us, and willing to offer assistance where sought.
I only wish that I could make use of that macro, but I have never been able to grasp more than the very basics of Excel due to maths blindness (somewhat akin to colour blindness!). Every time I look up Help, it seems to come up with formulae with what looks like trigonometry, algebra and other languages with which I was always hopeless at school. (That's why I went into a profession that uses words!)
Quentin
crivon1 wrote: I only wish
I only wish that I could make use of that macro, but I have never been able to grasp more than the very basics of Excel due to maths blindness (somewhat akin to colour blindness!). Every time I look up Help, it seems to come up with formulae with what looks like trigonometry, algebra and other languages with which I was always hopeless at school. (That's why I went into a profession that uses words!
I use Excel and have done some pretty amazing things with spreadsheets in the past.
Probably the most involved was a spreadsheet written on the TRS-80 Model 4 computer using Multiplan. The spreadsheet was for creating a price quotation and parts list for a sign company. One fed in the height of the sign, the size of the top portion of the sign and how many neon letters were required if any and finally what wind speed it had to endure. The spreadsheet looked up tables (given to me by the customer) that calculated the type pipe required to build the sign, it figured out the cost of the pipe as well as material to create the top of the sign and calc'd cost on any neon letters. It then figured depth of the pipe in the ground and calc'd the size and depth of hole required as well as the quantity of concrete required to keep things sturdy. It would print a price quotation for the customer and a parts list for the company. It took almost a year to create, but it was well worth it. It really was just automation of a time proven manual process they had come up with over time and practice.
Oddly enough I can do the numbers as well as words. What baffles me are cell phones.
admin wrote: Oddly enough I
Oddly enough I can do the numbers as well as words. What baffles me are cell phones. :D
Cellphones I can handle - if only I could see the keys and the screen
Your spreadsheet is way beyond my comprehension. However I should say that I do use Excel for things like administration accounts, records of staff holidays and illnesses (as well as AWOL!) and other simple things which require nothing more than addition or subtraction
admin wrote: I use Excel
I use Excel and have done some pretty amazing things with spreadsheets in the past.
Probably the most involved was a spreadsheet written on the TRS-80 Model 4 computer using Multiplan. The spreadsheet was for creating a price quotation and parts list for a sign company. One fed in the height of the sign, the size of the top portion of the sign and how many neon letters were required if any and finally what wind speed it had to endure. The spreadsheet looked up tables (given to me by the customer) that calculated the type pipe required to build the sign, it figured out the cost of the pipe as well as material to create the top of the sign and calc'd cost on any neon letters. It then figured depth of the pipe in the ground and calc'd the size and depth of hole required as well as the quantity of concrete required to keep things sturdy. It would print a price quotation for the customer and a parts list for the company. It took almost a year to create, but it was well worth it. It really was just automation of a time proven manual process they had come up with over time and practice.
Oddly enough I can do the numbers as well as words. What baffles me are cell phones. :D
Skip,
You and I are dating ourselves. I didn't think there was anybody left on planet Earth that ever had a TRS 80 model 4. In its time that was a great portable (i.e., pre-notebook). I loved that little bugger. Gave it to my sister and now she can't find it. Like baseball cards, I never should have let it go. Given the limitations of computers back then, I did amazing things with that little system. My first computer was a TRS 80 model I with 16 kB of RAM and the digital tape recorder. How's that for dating myself. Did some amazing things with that one too.
Like you, I did some pretty amazing things with Multiplan also. I wrote an entire spreadsheet to do all of the forms for my taxes by linking cells and sheets. To this day I still wish that they had never replaced Multiplan with Excel. I like Multiplan much better.
Both of these are dinosaurs now but I did a lot with them that I still do with current systems even though it was a lot harder and you only had floppy drives (single-sided 5 1/4).
Hope you kept yours, but like me you probably didn't.
Chuck Runquist
Former DNS SDK & Senior Technical Solutions PM for DNS
Chuck Runquist
I use Excel and have done some pretty amazing things with spreadsheets in the past.
Probably the most involved was a spreadsheet written on the TRS-80 Model 4 computer using Multiplan...
Oddly enough I can do the numbers as well as words. What baffles me are cell phones. :D
Skip,
You and I are dating ourselves. I didn't think there was anybody left on planet Earth that ever had a TRS 80 model 4. In its time that was a great portable (i.e., pre-notebook). I loved that little bugger. Gave it to my sister and now she can't find it. Like baseball cards, I never should have let it go. Given the limitations of computers back then, I did amazing things with that little system. My first computer was a TRS 80 model I with 16 kB of RAM and the digital tape recorder. How's that for dating myself. Did some amazing things with that one too.
Like you, I did some pretty amazing things with Multiplan also. I wrote an entire spreadsheet to do all of the forms for my taxes by linking cells and sheets. To this day I still wish that they had never replaced Multiplan with Excel. I like Multiplan much better.
Both of these are dinosaurs now but I did a lot with them that I still do with current systems even though it was a lot harder and you only had floppy drives (single-sided 5 1/4).
Hope you kept yours, but like me you probably didn't.
Mine was a TRS-80 Model 1 with 16k ram and tape drive too and it's still around somewhere as well as my Model 4 w/128mb ram and 10mb hard drive. None of them have been powered on in many years so I'd guess they probably wouldn't work now.
I think I liked Multiplan better as well. It seemed friendlier somehow. When Excel showed up it was (to me) a bastardized Multiplan and I found it offensive at the time. I tolerate it now but I'm not writing really large sheets anymore. Usually just a quick and dirty sheet to figure out a problem then it's gone.
The one thing that I always liked about TRSDOS/LDOS/NewDos was that you could save your system configuration to a file and change it on the fly without rebooting by loading a file. When I had to reboot on an IBM PC I remember thinking how primitive the OS was.