BDO TOOLS  -  Organise Fields Manage Folders Remove Duplicates

Example 1

If a file contains the following lines, the Organise Fields tool identifies 8 fields in each line.


 ab (null, Fiction    , 2001, Ashenden, Maugham,  12.50, One, 1))    ;
   ("BDO", "History", 2002 , "Discovery", "", , "",),))xyz)));;;);;
  x yz (x11, "Biography", 2003, "Memoirs",  "Berlioz",  33.00, "T", 3)

With the settings:
  Fields Required = 8,  Align Output = On
the output file will contain:

 (null,  Fiction,     2001, Ashenden,    Maugham,   12.50, One, 1);
 ("BDO", "History",   2002, "Discovery", "",        ,      "",  );
 (x11,   "Biography", 2003, "Memoirs",   "Berlioz", 33.00, "T", 3);

Using the same input file, with the settings:
  Fields Required = 8,  Align Fields = On,  Match Fields = On
a Field Match Inconsistency message is displayed, and no output is written.
 
Copyright © 2018 Brian D. Ogilvie www.bdozone.com  :