BDO Tools

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.