I would probably parse the | delimited file and stuff the elements into temp variables and then parse the variables using the = as the delimiter.
-- Bill Palmer Financial Coordinator, Information Systems Mid-Columbia Medical Center The Dalles, OR 97058 541-296-7417 >>> On 8/24/2007 at 9:58 AM, in message <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > 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.
