Paste the function I provided into the VBA editor - (I personally would add a module for the code, but it's not required)
Then in the Rules Action
You would have:
Enter cleanchars(d("field"))
Instead of
Enter D("Field")
Thom C. Blackwell
Vice President, Technical Services
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Learn about what we do <http://www.youtube.com/watch?v=Fbjk_4LUZYU>
Please follow us on Facebook
<http://www.facebook.com/pages/Boston-Software-Systems/122739774403349?>
and Twitter! <http://twitter.com/Bossoft>
LEGAL NOTICE Unless expressly stated otherwise, this message is
confidential and may be privileged. It is intended for the addressee(s)
only. Access to this E-mail by anyone else is unauthorized. If you are
not an addressee, any disclosure or copying of the contents of this
E-mail or any action taken (or not taken) in reliance on it is
unauthorized and may be unlawful. If you are not an addressee, please
inform the sender immediately, then delete this message and empty from
your trash.
From: [email protected] [mailto:[email protected]]
Sent: Monday, October 24, 2011 1:44 PM
To: Talk
Subject: RE: [talkbws] Entering a %
How would you do this using Rules?
Barbara A BeDell | Sr Consultant
<http://mhhealthcare.com/>
7600
<http://maps.google.com/maps?q=7600+W+110th+St,+Overland+Park+KS+66210&o
e=UTF-8&ie=UTF8&split=0&gl=us&ei=MEGoSZXBEI3Btgfji4XcDw&hl=en&sll=38.929
465,-94.67481&sspn=0.006295,0.006295&ll=38.93244,-94.673846&spn=0.006727
,0.014312&z=16&iwloc=addr> w 110th St, Overland Park, KS 66210
Mobile (773) 859-1226 E-mail [email protected]
Toll-Free (866) 491.3434 | eFax (866) 866.3622
www.mhhealthcare.com <http://mhhealthcare.com/>
CONFIDENTIALITY NOTICE: The information contained within this email is
intended for the addressee only. The message may contain confidential
information, and the wrongful distribution or communication of such
information is prohibited. If you receive this email in error please
notify the sender immediately by reply email and delete the email
including any attachments.
From: [email protected] [mailto:[email protected]]
Sent: Monday, October 24, 2011 10:53 AM
To: [email protected]
Subject: RE: [talkbws] Entering a %
Correct, that's the idea.
If you have +, or ^ you'd want to do the same thing.
With stuff like this, I'll use a function that way you catch all of them
at once.
Enter cleanchars(d("field"))
Function CleanChars(S as string) as string
S=replace(S,"%","%%")
S=replace(S,"^","^^")
S=replace(S,"+","++")
Cleanchars=S
End function
Thom C. Blackwell
Vice President, Technical Services
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Learn about what we do <http://www.youtube.com/watch?v=Fbjk_4LUZYU>
Please follow us on Facebook
<http://www.facebook.com/pages/Boston-Software-Systems/122739774403349?>
and Twitter! <http://twitter.com/Bossoft>
LEGAL NOTICE Unless expressly stated otherwise, this message is
confidential and may be privileged. It is intended for the addressee(s)
only. Access to this E-mail by anyone else is unauthorized. If you are
not an addressee, any disclosure or copying of the contents of this
E-mail or any action taken (or not taken) in reliance on it is
unauthorized and may be unlawful. If you are not an addressee, please
inform the sender immediately, then delete this message and empty from
your trash.
From: [email protected] [mailto:[email protected]]
Sent: Monday, October 24, 2011 10:47 AM
To: Talk
Subject: RE: [talkbws] Entering a %
Thanks Thom! I have only limited space (like 35 characters), so %% will
only enter one %, correct?
Reese E. Walker
Sr Systems Analyst, MSO/Physician Support
Phoebe Physician Group
(229) 312-5868
From: [email protected] [mailto:[email protected]]
Sent: Monday, October 24, 2011 10:44 AM
To: [email protected]
Subject: RE: [talkbws] Entering a %
The issue here is that % means something specific to the Enter command -
it's a signal to press the Alt key. That's what's causing your script
grief - it's doing exactly what it was told to do J
This will fix your problem:
Enter Replace(D("15"),"%","%%")
Doubling up the % using the Replace command instructs the enter command
to send the actual % character, not an Alt.
Thom C. Blackwell
Vice President, Technical Services
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Learn about what we do <http://www.youtube.com/watch?v=Fbjk_4LUZYU>
Please follow us on Facebook
<http://www.facebook.com/pages/Boston-Software-Systems/122739774403349?>
and Twitter! <http://twitter.com/Bossoft>
LEGAL NOTICE Unless expressly stated otherwise, this message is
confidential and may be privileged. It is intended for the addressee(s)
only. Access to this E-mail by anyone else is unauthorized. If you are
not an addressee, any disclosure or copying of the contents of this
E-mail or any action taken (or not taken) in reliance on it is
unauthorized and may be unlawful. If you are not an addressee, please
inform the sender immediately, then delete this message and empty from
your trash.
From: [email protected] [mailto:[email protected]]
Sent: Monday, October 24, 2011 10:32 AM
To: Talk
Subject: [talkbws] Entering a %
I have a need to be able to enter a % into a system from the data
station... Right now it is causing the script to stop... this is a note
file that I am entering into our system from a flat file from another
system.
D("15")="Peachcare 101-150% FPL 06/13/2011"
Enter D("15")
I guess I could replace the "%", but that might not make sense to anyone
who is reading the notes... Any other ideas?
Thanks,
Reese
Reese E. Walker
Sr Systems Analyst, MSO/Physician Support
Phoebe Physician Group
(229) 312-5868
Disclaimer:
The HIPAA Final Privacy Rule requires covered entities to safeguard
certain Protected Health Information (PHI) related to a person's
healthcare. Information being faxed to you may include PHI after
appropriate authorization from the patient or under circumstances
that do not require patient authorization. You, the recipient, are
obligated to maintain PHI in a safe and secure manner. You may not
re-disclose without additional patient consent or as required by
law. Unauthorized re-disclosure or failure to safeguard PHI could
subject you to penalties described in federal (HIPAA) and state
law. If you the reader of this message are not the intended
recipient, or the employee or agent responsible to deliver it to
the intended recipient, please notify us immediately and destroy
the related message.
--- To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
--- To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected] Unsubscribe in the
customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
Disclaimer:
The HIPAA Final Privacy Rule requires covered entities to safeguard
certain Protected Health Information (PHI) related to a person's
healthcare. Information being faxed to you may include PHI after
appropriate authorization from the patient or under circumstances
that do not require patient authorization. You, the recipient, are
obligated to maintain PHI in a safe and secure manner. You may not
re-disclose without additional patient consent or as required by
law. Unauthorized re-disclosure or failure to safeguard PHI could
subject you to penalties described in federal (HIPAA) and state
law. If you the reader of this message are not the intended
recipient, or the employee or agent responsible to deliver it to
the intended recipient, please notify us immediately and destroy
the related message.
--- To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
--- To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
--- To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [email protected]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk
.aspx
Legal Notice: This electronic message transmission and any attachments
contain information from Fauquier Health System which may be
confidential or privileged. This e-mail is intended only for the
addressee. If you are not the intended recipient, be aware that any
disclosure, copying, forwarding, distribution, or use of the contents of
this transmission is prohibited. If you have received this electronic
transmission in error, please notify the sender immediately and delete
the original message from your system. Fauquier Health System makes no
warranty that this e-mail is error or virus free. Thank you.
--- To post a message to this list, send mail to: [email protected] You are
currently subscribed as: [email protected] Unsubscribe in the
customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx <<image001.png>>
