TextFile.Delimitation Property |
Sets and returns the method of field delimitation for a database text file.
TextFile.Delimitation = BtTextFileDelimitation
Where BtTextFileDelimitation can be set to any of the following constants:
btDelimMixedQuoteAndComma: The text file is mixed quote and comma delimited; has a value of 0.
btDelimQuoteAndComma: The text file is quote and comma delimited; has a value of 1.
btDelimComma: The text file is comma delimited; has a value of 2.
btDelimTab: The text file is tab delimited; has a value of 3.
btDelimCustom: The text file is delimited by the FieldDelimiter property; has a value of 4.
Version |
BarTender 6.00 or higher |
Edition |
Automation, Enterprise |
'Declare a BarTender application variable
Dim btApp As BarTender.Application
'Declare a BarTender document variable
Dim btFormat As BarTender.Format
'Declare a BarTender database variable
Dim btDb As BarTender.Database
'Create a new instance of BarTender
btApp = New BarTender.Application
'Set the BarTender application visible
btApp.Visible = True
'Open a BarTender document
btFormat = btApp.Formats.Open("c:\Format1.btw", False, "")
'Select the database
btDb = btFormat.Databases.GetDatabase(1)
'Set delimitation type to custom
btDb.TextFile.Delimitation = BarTender.BtTextFileDelimitation.btDelimCustom
'Set the custom delimiter
btDb.TextFile.FieldDelimiter = ":"
'End the BarTender process
btApp.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges)
// Declare a BarTender application variable
BarTender.Application btApp;
// Declare a BarTender document variable
BarTender.Format btFormat;
// Declare a BarTender database variable
BarTender.Database btDb;
// Create a new instance of BarTender
btApp = new BarTender.Application();
// Set the BarTender application visible
btApp.Visible = true;
// Open a BarTender document
btFormat = btApp.Formats.Open("c:\\Format1.btw", false, "");
// Select the database
btDb = btFormat.Databases.GetDatabase(1);
// Set the delimitation type to custom
btDb.TextFile.Delimitation = BarTender.BtTextFileDelimitation.btDelimCustom;
// Set the delimiter
btDb.TextFile.FieldDelimiter = ":";
// End the BarTender process
btApp.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges);
Related Topics