Read Text File

readtextfileThis Analytics Edge wizard allows you to import a text file into a table. I accepts both delimited files as well as fixed-width fields.

While the date format of the source file can be specified, you can follow up with a Convert function to handle any text, number or date conversions desired.

File/URL – enter or browse to the specific file to be loaded, or enter a direct URL to a web-based file.

Split on delimiter – select or enter a delimiter to use when reading the file.

Split into fixed width fields – if the file uses fixed width fields, select this option and continue to the next wizard panel (below).

File type – read a special file type. Currently only JSON files can be read.

File does not contain a header row – select this if the data does not contain column names.

Transpose – read the data in, swapping rows of data into columns. The first column in the row will be treated as the transposed column name.

Date format in file – enter codes to represent the exact date format used in the source file. Analytics Edge will recognize columns as dates if all of the values match that format. Pay specific attention to matching single or two-digit days, months or time components.

readtextfile2If the file uses fixed width fields, the first few rows of the file will be displayed. Click with the mouse to insert a red line between each field column.

To delete a line, click slightly to the right of the line.

readtextfile3Select Column Types

Similar to Excel functionality, you can select a column and change the data format to be used for that column. By default, all columns are of type ‘General’, which means numbers and date columns should be automatically recognized.

If the file uses an odd date format, you can select from the drop-down or enter date format codes to match the source. The codes must match exactly for the column to be recognized (see Date Format).