BDO Tools

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");