Loading Data from Fixed width File

Hi All,

 

what are different option available for source_data_format parameter for TSLOAD utility in TS.

1. Can we load data from fixed width file into TS?

2. Can we load data from file with character set "UTF16" into TS?

 

Thanks in advance.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • As per the docs, there are only two options for that.. Its either csv or delimited. 

     

    1. So essentially there is no option for fixed width file.. You typically have an option to insert a delimiter in your extraction stage. If you dont have control over the extraction process, you could try some linux file tricks to get that delimiter in place

    2. It needs to be UTF8. tsload is pretty strict that way...

    Reply Like 1
Like Follow
  • Status Answered
  • 3 mths agoLast active
  • 1Replies
  • 13Views
  • 2 Following