BDO TOOLS  -  Make Fields Align Fields Manage Folders

Table Name

When the Enclosed control is selected, the Table Name box is activated.

When a table name is specified (and the Save As type is Text), output from the Make Fields tool is a file containing SQL statements.

Example

Consider an input file containing the following lines:

 1 Humphrey Bogart
 2 Ingrid Bergman
 3 Paul Henreid
 4 Peter Lorre
 5 Анна Стен
 6 Sydney Greenstreet

Using appropriate column widths, quoting fields 2 and 3, enclosing the fields with parentheses, using the default delimiter (a comma), trimming the output and specifying a table name of actors, the output file, when saved as Text, will contain:

 insert into actors values (1, "Humphrey", "Bogart");
 insert into actors values (2, "Ingrid", "Bergman");
 insert into actors values (3, "Paul", "Henreid");
 insert into actors values (4, "Peter", "Lorre");
 insert into actors values (5, "Анна", "Стен");
 insert into actors values (6, "Sydney", "Greenstreet");
 
Copyright © 2018 Brian D. Ogilvie www.bdozone.com  :