All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Here's how I have handled sitations like this. Lots of times, I put a header record to describe the delimited fields for quality control purposes. I was getting quite tired of updating line checks. So what I did was create a computed field on page 2 with the IG (ignore) xx.header IG with prompt HEADER? Defaulted to N Then on the line check do : LC=c.xx.header="Y" Probably could do similar logic for COMMA/QUOTE delimited. James Purvins Inland Northwest Health Services (509) 232-8384 This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, or have otherwise received this communication in error, please delete it from your inbox, notify the sender immediately by replying to the message, and do not disclose its contents to any other person, use the information for any purpose or store or copy the information in any medium. Thank you for your cooperation -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ganesh Seshadri Sent: Thursday, April 27, 2006 6:20 AM To: [email protected] Subject: [MEDITECH-L] ? NPR R/W: removing quotes in download files All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== we have numerous instances where we download data and send them off as data files, usually comma separated. i have had several requests for minor changes - eg. semicolon or tab separated instead of comma which is straightforward. the one that is cumbersome is when some requests want the data in quotes while others dont want quotes. it's very cumbersome to edit every definition and reset each to DAT=FREE or DAT=INT. does anyone have suggestions on how this can be done without this laborious process? i prefer not to explicitly format and print the lines in a macro because it makes it hard for others to maintain the report, so this should be with meditech's standard strategy for download files ie., FD 44, RL nnn, SFF/EFF NO etc. i would even have considered duplicating each line, printing once with quotes and once without, and line checking the part that i dont need for a given download based on a selection condition, but this will add an extra null field at the beginning of the record. tia, regards, ganesh seshadri, indiana regional _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
