Search found 14 matches

by andrewbarbour
Tue May 10, 2016 2:18 pm
Forum: The Water Cooler
Topic: The power.....
Replies: 4
Views: 11485

The power.....

Every now and then when working with MS - the feeling I get is like....

Image
by andrewbarbour
Tue May 10, 2016 2:16 pm
Forum: The Water Cooler
Topic: Video Tutorial Recording?
Replies: 5
Views: 9661

Re: Video Tutorial Recording?

It is not cheap.... but my preference is Camtasia Studio. Get the package with Snagit (USD$325). I use these tools every day! We have folks using way more expensive products with a recording/production studio in my office (it is their full-time gig) and I put out content faster than they do and at c...
by andrewbarbour
Mon Apr 25, 2016 3:04 pm
Forum: Enhancement Suggestions
Topic: Notes on macro in list view
Replies: 1
Views: 4427

Notes on macro in list view

It would be soooo nice to have a notes option for each macro - and be able to display it in the Macro list view. Something that would allow you to take better notes about the macro, its purpose, client name etc. There is a fair bit of realestate in the window now and no option of adding columns to t...
by andrewbarbour
Sun Apr 10, 2016 11:59 pm
Forum: Enhancement Suggestions
Topic: Ability to easily shuffle an array
Replies: 1
Views: 4369

Ability to easily shuffle an array

I had posted a question in another one of the groups - and got a fantastic answer I have a list of individuals that I need to randomize the order of... Bob,Mary,Bill,Thomas,Jack,Jimbo All I need to do is put them in random order in a new string. I thought this would be easy.... the code I have found...
by andrewbarbour
Fri Apr 08, 2016 7:11 pm
Forum: Technical / Scripting
Topic: Randomizing elements of a string
Replies: 13
Views: 8915

Re: Randomizing elements of a string

When I complete my solution I will post it all here - as long as nobody gives me too much grief for my coding skills... My first cut got the time down from 8 hours per month to 25 minutes. And considering the individuals doing the schedule were SENIOR physicians - you can imagine the cost savings th...
by andrewbarbour
Fri Apr 08, 2016 3:34 pm
Forum: Technical / Scripting
Topic: Randomizing elements of a string
Replies: 13
Views: 8915

Re: Randomizing elements of a string

change let>teller=0 into let>teller=-1 and then the bug is exterminated ... i hope... :D That did not work entirely for me - the incidents of only 5 items in the list were as follows: Trial 1 - 4/100 had only 5 items after the shuffle Trial 2 - 2/100 Trial 3 - 9/100 It was the third line below you ...
by andrewbarbour
Fri Apr 08, 2016 3:25 pm
Forum: Technical / Scripting
Topic: Randomizing elements of a string
Replies: 13
Views: 8915

Re: Randomizing elements of a string

AWESOME! You have no idea how long this took me.... I should have posted sooner. So much more elegant than what I was doing (or rather trying to do). You ever take on a project and it is FAR more complex than you thought? I am trying to optimize the shift schedules for a group of employees. And then...
by andrewbarbour
Thu Apr 07, 2016 10:09 pm
Forum: Technical / Scripting
Topic: Randomizing elements of a string
Replies: 13
Views: 8915

Randomizing elements of a string

I have a list of individuals that I need to randomize the order of... Bob,Mary,Bill,Thomas,Jack,Jimbo All I need to do is put them in random order in a new string. I thought this would be easy.... the code I have found in the forums is a little difficult to follow. Any ideas? EDIT: A GREAT feature f...
by andrewbarbour
Wed Jun 24, 2015 2:22 pm
Forum: Technical / Scripting
Topic: Unicode character - how to replace? XML validation error
Replies: 4
Views: 4530

Re: Unicode character - how to replace? XML validation error

Thanks Marcus.... here is an extract of the relevant lines. A few caveats: - it is probably way to complicated - as I am a business guy - not a coder - I know I should use subroutines - I tend to write my first proof of concept in a linear format - then start fresh and write it tight The following a...
by andrewbarbour
Mon Jun 22, 2015 2:59 pm
Forum: Technical / Scripting
Topic: Unicode character - how to replace? XML validation error
Replies: 4
Views: 4530

Unicode character - how to replace? XML validation error

I am extracting the text from an Excel cell doing some manipulation and then writing it out as a line to an XML file. When I try and validate it using http://xmlvalidation.com/ it tells me there is a problem with a character.... The validator tells me it is "Unicode: 0x1" I have tried pasting the ch...
by andrewbarbour
Thu Feb 14, 2013 7:26 pm
Forum: General Discussion
Topic: Position command and comma??
Replies: 4
Views: 9785

Thanks!

That works! Thanks
Rain wrote:Try

Code: Select all

Let>strLine=blah blah blah), A. Fitzsimons (XX), C. Gannage (YYY)
Position>),%strLine%,1,dPos,FALSE
mdl>dPos
by andrewbarbour
Thu Feb 14, 2013 5:43 pm
Forum: General Discussion
Topic: Position command and comma??
Replies: 4
Views: 9785

Position command and comma??

I am trying to find the position of a substring in a string. I am looking to find the position of the "close bracket comma space" i.e "), " Let>strLine=blah blah blah), A. Fitzsimons (XX), C. Gannage (YYY) Position>), ,strLine,X,dPos,FALSE I get an "error in position command". It would seem like the...
by andrewbarbour
Wed Mar 30, 2011 3:50 pm
Forum: Technical / Scripting
Topic: Globally Recognized Avatars (Gravatars)
Replies: 0
Views: 6200

Globally Recognized Avatars (Gravatars)

For the past few months I have been using the gravatar service (http://www.gravatar.com) so I do not have to keep updating my avatars on various sites. Your avatar is referenced through a link which uses a hash of your email address. This way any site that has your email address can potentially pull...
Sign up to our newsletter for free automation tips, tricks & discounts