<< Click to Display Table of Contents >> Navigation:  Sources > Text

To extract data from text files containing fixed with fields, pass field sizes in parameters. Example:

 

select * from fixed(true, 12,12,15)

 

If first row is header row, columns can be referenced by its names from first row and firs row is skipped. To use this mode pass true as first parameter, otherwise columns are named in Excel style.