Escaping password with special characters.

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
philb
Newbie
Posts: 2
Joined: Mon Aug 06, 2018 3:49 pm

Escaping password with special characters.

Post by philb » Wed Aug 08, 2018 9:32 am

Hi,

I've used Macro Scheduler to create a macro that opens an excel document, filters the data and saves it out. I time how long it takes and upload the results to a time series database.

The macro works with my testing credentials and everything reaches the database however when i use the proper credentials it fails.

I know how to escape special characters for the database itself but i wanted to know how i would escpape the characters in MS. The credentials are sent as part of the URL like below

Code: Select all

Let>URL=https://myserver.local:8086/write?db=macro_test&u=philb&p=P@ssW0rD!.
Obviously i've omitted the real password, but the one above is similar in that it contains the same special characters.

I've read a couple of topics on here and looked in the manual but i wasn't able to work it out from there, is someone able to offer some advice? The characters i need to escape specifially are @ ! and .

Thanks

User avatar
Marcus Tettmar
Site Admin
Posts: 7378
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Escaping password with special characters.

Post by Marcus Tettmar » Wed Aug 08, 2018 4:48 pm

Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

philb
Newbie
Posts: 2
Joined: Mon Aug 06, 2018 3:49 pm

Re: Escaping password with special characters.

Post by philb » Tue Aug 14, 2018 10:03 am

Hi Marcus,

Thanks for the response. Sorry i've only just seen this today, I'm in between different projects and have just got back round to this but I will give that a try this now.

Thanks for your time.

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts