CLOB Format

The CLOB format is used to load the entire content of the file into a single column in a data set.

It can be extremely useful when you just want to make a few changes in the source document without applying a full-fledged source-to-destination transformation. 

To create a new CLOB format go to Connections, select Formats tab, click Add Format button and type in clob in the search field. 

The following parameters are available when configuring the format:

• Column Name - the value of this property will be used as a column name when loading the content of the file into a single column in a data set.  The default column name is content.
• Default Extension - the default extension is used when the file name doesn't have an extension. If not entered, txt is the default extension.
• Preprocessor - this is code written in JavaScript, which is used to change the entire document. Read more about the preprocessor. 
• Encoding - character encoding when reading and writing a file. No encoding means there will be no additional encoding.