Gary: another option that we have done here would be to open your excel file before opening in datastation and sort the file so the blank lines are at the bottom. We have used this and Boston does a fabulous job at opening excel and sorting consistently.
Kim Scaccia, System Admin Recovery Reimbursement Patient Business & Financial Services Halifax Medical Center 386-226-4590 opt 1 ext 2018 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibbs, David Sent: Friday, May 11, 2007 12:24 PM To: [email protected] Subject: RE: [Talk] Excel in datastation Another solution would be to check your record after D.Next_ and in your DBCheck and if D("Whatever")="" just get another record. I would also keep a count of how many consecutive "" you find and exit after x many as you are likely at the end of the file. One of the support guys at BWS suggested that relying on EOF in Excel can be a bit tricky as you can sometimes have a sheet with 30 lines of real data and 64450 or so of blank data. This can create a lot of script cycles looking for nothing! David Gibbs LIS Analyst Fraserhealth ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence, Mitchell Sent: May 11, 2007 5:52 AM To: [email protected] Subject: RE: [Talk] Excel in datastation If the blank line situation is consistent, when you do your D.Next_, just do two. :-) Thank you, Mitch Lawrence Lead Applications Analyst - Advanced Report Writer General Financials Support CHRISTUS Information Management ': 361.881.3408 7: 361.888.6117 *: 361.549.8456 )AIM: a1d13 )MSN: [EMAIL PROTECTED] *: [EMAIL PROTECTED] Send a "thank you" <http://intranet.christushealth.org/spiritBuck/> to someone! ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Williams Sent: Friday, May 11, 2007 7:41 AM To: [email protected] Subject: [Talk] Excel in datastation The excel sheet I am to use for input has blank lines between every record. When I bring this into the data station every other record is blank. Is there a way to have the script remove tthe blank lines? Or will I have to have them remove the lines beforeI get the file? Thanks, Gary
<<image001.gif>>
