Data Sources|Flat Files|Delimited Text Files

Delimited Text Files

Data Med+c modules process delimited text files with no additional driver software required.

The text files should be :-



Delimited fields are processed 'as they are', except where they are enclosed within field enclosing characters ( " and ' by default). Therefore, where no field enclosing characters wrap the actual field value, the field value is processed as is.

However, where field enclosing characters wrap field value, the field enclosing characters are firstly removed, before the remainder of the field value is processed.

Upon loading a delimited text source file, Data Med+c attempts to work out what the likely field delimiter is and how many fields there are in the source file. Data Med+c makes a reasonable guess based on a set of supported field delimiters it recognises. These are :-


If Data Med+c gets its choice of field delimiter wrong, then you can simply change it using the screen controls.


Caution

Source files may be amended or changed by Data Med+c If your source files are valuable, please make additional backup copies of them before using Data Med+c.