Greetings,
Try enter strReplace(d("Acct Num"),"'","")strReplace says in "this", look for "this", and replace it with "this". Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com Sign up for my weekly webinar! 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. -----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.
