Clayton,
I don't use the rules based, but here is something I do to remove
the colon from a time stamp.
StrJustify(Trim(StrReplace(Time, ":", "")), 4)
So can you use something like this?
Enter Trim(StrReplace(D("Acct Num"), "'", ""))
M. June Owen
Systems Analyst
Community Health Network
(317) 355-3015
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, December 14, 2007 4:19 PM
To: [email protected]
Subject: RE: [Talk] Problem with trim
I am trying to take a rules base excel document that has a number or
string: '0123456789
I need only the 10 numbers not the single quote '
I know i want the trim or the String right But what is the syntax and
where do i have to put it?
in the actions i have
Enter D("Acct Num") '0123456789
all i want is 0123456789
Thank you.
Clayton Leach
Integration Analyst
Phone 937-328-8104
FAX 937-328-6222
Information Systems
Community Mercy Health Partners
CONFIDENTIALITY NOTICE: This message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential
and
privileged information. Any unauthorized review, use, disclosure or
distribution
is prohibited. If you are not the intended recipient, please contact
the
sender by reply e-mail and destroy all copies of the original message.
