RE: [Talk] Problem with trim

[cpleach]

I didn't write that how i meant , was frustrated.
Thank you for the syntax.
I am actually in the visual basic editor.
I'm new to the area.
Thank you.
Clayton Leach
Integration Analyst
Phone 937-328-8104
FAX 937-328-6222
Information Systems
Community Mercy Health Partners


                                                                           
             "Owen, June"                                                  
             <[EMAIL PROTECTED]                                             
             .com>                                                      To 
             Sent by:                  <Talk@BOSTONWORKSTATION.COM>        
             [EMAIL PROTECTED]                                          cc 
             WORKSTATION.COM                                               
                                                                   Subject 
                                       RE: [Talk] Problem with trim        
             12/14/2007 04:58                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             [EMAIL PROTECTED]                                             
                 ATION.COM                                                 
                                                                           
                                                                           



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: Talk@BOSTONWORKSTATION.COM
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.




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.