Sign up Calendar Latest Topics Donate
 
 
 


Reply
  Author   Comment  
RustyCas

Avatar / Picture

Admin
Registered:
Posts: 1,810
Reply with quote  #1 
First thing I do when starting a report is go to Exception Analysis and print a Notepad Observations Summary.  I set my Output Destination as Previewer, and turn off Pause Between Stations.  What I get is a file with observations for each Area (and there are a lot).  What bugs me is, it doesn't insert a CR/LF (carriage return/line feed) at the end of the listing for each Area, and it ends up looking like the example below.  Not a big deal really, but it drives me nuts because it used to insert the CR/LF and it looked like the 2nd example.  I can't figure out how to get it back to the way it used to be.

Have any of you run into this?  Am I the only one who does this?  Am I the only one who cares if it's formatted properly?

(with no CR/LF)

Notepad Observations Summary Report
***********************************

Database: NYS.rbm
Area: NYS1 BAGHOUSE
Report Date: 12-Dec-16 19:55


POINT DATE OBSERVATIONS
----- ---- ------------

1BH-RAF3 --> REVERSE AIR FAN 3
FIH 07-Dec-16 EXTRA DATA
FIV 07-Dec-16 EXTRA DATA

1BH-RAF4 --> REVERSE AIR FAN 4 (SOUTH)
FIV 07-Dec-16 ** FIELD ALERT - REVIEW DATA **

SEAL6 --> SEAL AIR FAN 6 (North)
MIH 07-Dec-16 ** FIELD ALERT - REVIEW DATA ** Notepad Observations Summary Report
***********************************

Database: NYS.rbm
Area: CANOPY BAGHOUSE
Report Date: 12-Dec-16 19:55


POINT DATE OBSERVATIONS
----- ---- ------------

***** NO NOTEPAD OBSERVATIONS WERE FOUND ***** Notepad Observations Summary Report
***********************************

(the way it should look)

Notepad Observations Summary Report

***********************************

Database: NYS.rbm
Area: NYS1 BAGHOUSE
Report Date: 12-Dec-16 19:55


POINT DATE OBSERVATIONS
----- ---- ------------

1BH-RAF3 --> REVERSE AIR FAN 3
FIH 07-Dec-16 EXTRA DATA
FIV 07-Dec-16 EXTRA DATA

1BH-RAF4 --> REVERSE AIR FAN 4 (SOUTH)
FIV 07-Dec-16 ** FIELD ALERT - REVIEW DATA **

SEAL6 --> SEAL AIR FAN 6 (North)
MIH 07-Dec-16 ** FIELD ALERT - REVIEW DATA **

Notepad Observations Summary Report
***********************************

Database: NYS.rbm
Area: CANOPY BAGHOUSE
Report Date: 12-Dec-16 19:55


POINT DATE OBSERVATIONS
----- ---- ------------

***** NO NOTEPAD OBSERVATIONS WERE FOUND *****

Notepad Observations Summary Report
***********************************


__________________
"The trend is your friend"
Aubrey

Avatar / Picture

Sr. Member
Registered:
Posts: 87
Reply with quote  #2 
Hi Rusty,

When I had the pleasure of working with MHM I would always export everything out to Excel.

I could either make a macro or write a vba script to do the cleanups for me. After you got the script made it was pretty easy. Find and Replace is pretty easy to do.

I put the raw data on one spreadsheet and put what I wanted on another. I then wrote the macro to make the data match the report I wanted.

I left all that for the analyst that replaced me a few years back though. I don't have the files with me anymore. I couldn't use them using Commtest...


__________________
Aubrey
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.