Wow, I've learned about 2 great techniques today! Shirley Hammack I.T. Financial Analyst Jackson County Memorial Hospital 580-477-7484
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thom C. Blackwell Sent: Friday, August 24, 2007 12:33 PM To: [email protected] Subject: RE: [Talk] String Extraction / Mulitple Delimiters Greetings, The BWS StrWord command is ideal here (it is one of my favorite BWS commands) It basically says give me the "nth" item delimited by X. Syntax: myData=StrWord(ExtractFrom, nth item, delimiter) So to do what you want: Enter StrWord(d("Field1"),2,"=") This will enter the second "thing" delimited by the =. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com 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] On Behalf Of Stephen R. Smesny Sent: Friday, August 24, 2007 12:59 PM 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. --------------------------------------------------------------------------------------------- This email has been scanned by the JCMH IronPort appliance and has been cleared for delivery. If you have any concerns or questions, call the IT Helpdesk at x2646. --------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------ The documents accompanying this transmission contain confidential information, belonging to the sender, that is legally privileged. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any reading, disclosure, copying, distribution, or action taken in reliance on the contents of these documents is strictly prohibited. Violators may be prosecuted. If you have received this email in error, please notify the sender immediately and destroy the transmitted information. ------------------------------------------------------------------------------------------------------------------------------------
