EZPNFUTL is a collection of utility programs that operate on ASCII data
files. The ascii data files may come from internet data providers,
'export' features of stock analysis programs, spreadsheets, or even word
processors.

EZ-PnF can read over 1580 formats of User defined ASCII data files, but
there are some basic requirements ie the data has to be comma delimited
and the data has to be ordered in an oldest->newest date order.

Unfortunatley, some data sources ie some spreadsheet programs and some
data export features only create ASCII data files that are delimited with
the SPACE or TAB character.

The ASCII data utilities contained in EZPNFUTL solve most, if not all, of
these problems.
 

-------------------------------------------------------------------------

                                                     Installation:

The EZPNFUTL package is included inside of all of the EZPNF23R.EXE installer/setup
packages. In Windows installations the EZPNFUTL programs will be automatically installed.
In Dos installations, click on, or run, ezpnfutl.exe and it will expand and extract 
all the utilities included. 

The following utility programs should now appear in the \ezpnf
folder/directory:

EZSP2CSV  converts all the SPACEs in an ASCII file into commas.
           Great for spreadsheets that only export 'space' delimited data.

EZTB2CSV   converts all the TABs in an ASCII file into commas.
           Great for spreadsheets or data providers that use TAB as the
           delimiter character.

EZREVERS   Takes an ASCII  file and reverses it's order ie the original
           first line is the last, and the original last line is now the first line.

-------------------------------------------------------------------------

                                                 Use/Syntax/Examples

All Programs:

All the utility programs share 2 common modes of execution.

1) They can be run from a DOS command line from within the ezpnf
   folder/directory. Filename wildcards supported from the command line.

   For HELP from the DOS command line:
   c:\ezpnf>utilityname       gives short form syntax help
   c:\ezpnf>utilityname help  gives long form syntax help and examples.

   To RUN a utility with one source file as input:
   c:\ezpnf\utilityname  sourcefilename.sourcefileextension
   Utility executes on the source file. If an error occurs, a message
   is displayed. Press any key to clear the error message and continue.

   To RUN utility with more than one input file:
   Display and read the long form of the utility syntax help.
   See specific examples below.

OR

2) In Windows Explorer (or Fileman), you can select up to 4 source files
   and 'drag and drop' them onto the utility program's icon.

   Utility executes on the 'dropped' files. If an error occurs, a message
   screen pops up. Press any key to clear the error message and continue.

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

EZSP2CSV

EZSP2CSV is a utility to convert all spaces in an ASCII data file into
         commas.

EZSP2CSV creates a new file with the original filename and a .CSV
         extension. All space characters from the original file are
         converted to commas. This is useful with stock price data files
         exported from IQSuite.  EZSP2CSV can convert single files or all
         files with a common file extension.

Examples: (with EZSP2CSV in the \ezpnf directory/folder)
  EZSP2CSV abc.txt  creates/converts the abc.txt file into abc.CSV
  EZSP2CSV abc.txt 123.dat creates/converts the files into abc.CSV 123.CSV
  EZSP2CSV abc.txt 123.dat ibm.xyz x.txt vgpmx.2 dsawq.!! xon.zzz 777.ers
           creates/converts the files into abc.CSV 123.CSV ibm.CSV x.CSV
           vgpmx.CSV dsawq.CSV xon.CSV 777.CSV
  EZSP2CSV *.txt  creates/converts all .txt files in \ezpnf to .CSV files.
  EZSP2CSV a:\xyz.dat creates/converts the xyz.dat file in the A: drive
                    into A:\xyz.CSV
  EZSP2CSV d:\data\*.dat creates/converts all .dat files in the d:\data
                    folder into .CSV files in the d:\data folder.

NOTE: EZSP2CSV will NOT process a file with a .CSV extension as an input.

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

EZTB2CSV

EZTB2CSV is a utility to convert all tabs in a data file into commas.

EZTB2CSV creates a new file with the original filename and a .CSV
         extension. All tab characters from the original file are
         converted to commas. This is useful with stock price data
         files exported from many spreadsheet programs. EZTB2CSV can
         convert single files or all files with a common file extension.

Examples: (with EZTB2CSV in the \ezpnf directory/folder)
  EZTB2CSV abc.txt  creates/converts the abc.txt file into abc.CSV
  EZTB2CSV abc.txt 123.dat creates/converts the files into abc.CSV 123.CSV
  EZTB2CSV abc.txt 123.dat ibm.xyz x.txt vgpmx.2 dsawq.!! xon.zzz 777.ers
           creates/converts the files into abc.CSV 123.CSV ibm.CSV x.CSV
           vgpmx.CSV dsawq.CSV xon.CSV 777.CSV
  EZTB2CSV *.txt  creates/converts all .txt files in \ezpnf to .CSV files.
  EZTB2CSV a:\xyz.dat creates/converts the xyz.dat file in the A: drive
                    into A:\xyz.CSV
  EZTB2CSV d:\data\*.dat creates/converts all .dat files in the d:\data
                    folder into .CSV files in the d:\data\ folder.

NOTE: EZTB2CSV will NOT process a file with a .CSV extension as an input.

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

EZREVERS

EZREVERS is a utility to reverse the order of lines in an ASCII file.

EZREVERS reverses/inverts the order of the lines in an ASCII input file.
         The original first line becomes the last line and the original
         last line becomes the first line. This is useful with stock
         price data files exported/downloaded from certain data providers.
         EZREVERS can convert single files or all files with a common file
         extension.

Examples: (with EZREVERS in the \ezpnf directory/folder)
  EZREVERS abc.txt  reverses the abc.txt file.
  EZREVERS abc.txt 123.dat reverses the files.
  EZREVERS abc.txt 123.dat ibm.xyz x.txt vgpmx.2 dsawq.!! xon.zzz 777.ers
           reverses all the files listed.
  EZREVERS *.txt  reverse all .txt files in \ezpnf.
  EZREVERS a:\xyz.dat reverse the xyz.dat file in the A: drive
  EZREVERS d:\data\*.dat reverse all .dat files in the d:\data folder

NOTE: The original file is changed. To restore, just re-run the utility.

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

-------------------------------------------------------------------------

                          Disclaimer/Warranty

Please Note: The utility programs contained in EZPNFUTL are data tools.
The user assumes all responsibility for the use of these tools. It is
important to remember that some of the utiltiy programs will change data
on your computer system. It is the user's responsibility to take
reasonable precautions ie backing up data files before using the
EZPNFUTL utilities.

While all care was taken in the writing of the EZPNFUTL utility programs:

  EZPNFUTL AND IT'S INCLUDED PROGRAMS ARE PROVIDED "AS IS" WITHOUT
  WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT
  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A
  PARTICULAR PURPOSE.

--------------------------------------------------------------------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
                                              EZPNFUTL License Statement

EZPNFUTL, and it's included programs, are REGISTERED
and Copyright (c)1999 BCA Software. All Rights Reserved.

EZPNFUTL, and it's included programs, are the property of BCA Software
and are licensed for use by REGISTERED USERS of EZ-PnF. Any other
use or distribution is a violation of copyright law.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<