Here is the code for extracting the string from the output you are getting
from the datastation
ALLAFTEREQUAL = mid(D("VARNAME"), (instr(1, D("VARNAME"), "=") +1),
len(D("VARNAME")))
...................................
Brian Van Grinsven
Integrated Systems Specialist
Medbuy Corporation
mailto:[EMAIL PROTECTED]
http://www.medbuy.ca
T: 519.652.1688 ext. 114
F: 519.652.2788
Technical Support:
ext. 199 or [EMAIL PROTECTED]
Building Partnerships in Healthcare
"Stephen R. Smesny" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/24/2007 12:58 PM
Please respond to
[email protected]
To
<[email protected]>
cc
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 e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient, please
notify the sender immediately by return e-mail, delete this e-mail and
destroy any copies. Any dissemination or use of this information by a
person other than the intended recipient is unauthorized and may be
illegal.
**********************************************************************
