Try this:
STRAfterEquals = Right(STRWholeString,InStr(STRWholeString,"=")) Where STRAFterEquals is your resulting "After the equalsign" text and STRWholeString is your beginning value. Thank you, Mitch Lawrence Lead Applications Analyst Technical Support - NPR/Automation CHRISTUS Information Management *: [EMAIL PROTECTED] Send a "thank you" <http://intranet.christushealth.org/spiritBuck/> to someone! _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen R. Smesny Sent: Friday, August 24, 2007 11:59 AM To: [email protected] Subject: [Talk] String Extraction / Mulitple Delimiters I have a pipe delimited file that produces records as follows when opened in datastation: 1 MT6=1 2 EY5=1 3 EY8=08/23/2007 4 G8=0 .........and so on When keying these records into the application I only need the application to key the data to the right of the '=' sign. What string extraction command can I use to accomplish this? Or another solution to my problem would be to parse the file using 2 delimiters. I would need to open the file with '|' and '=' as a delimiter. Then the actual fields I would need to key would be in every other field which would not be a problem. I am just not sure if it is possible to open a file in datastation like this. Thanks in advance for any help or suggestions. Stephen Smesny Programmer \ Analyst Beaufort Memorial Hospital [EMAIL PROTECTED] 843-522-7915 ********************************************************************** The information contained in this electronic communication, and any electronic attachment(s), is CONFIDENTIAL and is intended only for the named recipient(s) above. If the reader of this message is not the intended recipient(s), you are hereby notified that any release of information or distribution of this communication is prohibited by law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender via reply email and delete this communication. ********************************************************************** This message was scanned with MIMESweeper.
<<image001.jpg>>
