Share
ReportIs .tsv an accepted file format for import? I am only familiar with .dat or .csv .
*This post is locked for comments
You’re offline. This is a read only version of the page.
Is .tsv an accepted file format for import? I am only familiar with .dat or .csv .
*This post is locked for comments
Thanks alot.
If you use a simple control file, only comma-separated values are accepted.
If you use the "Intelligent" control file, in theory you can use any character as separator: comma, semi-colon, colon, tab, &, etc.
Please consider that the file extension (.dta, .csv, .txt or whatever) doesn't have any meaning to the import process. If you use a simple control file, SL will expect a comma separated file even if you supply contoso.tsv.
If you want to use tab-separated values, you should produce a intelligent control file and set a separator like in the following sample:
All responses (
Answers (
16'$include: "bsl.dh"
'24271 Control Macro
Sub ProcessImportLine( LevelNumber%, Retval% )
select Case LevelNumber
case TI_Start
call AliasConstant( "Level0", "CurrencyRate" )
Call AliasConstant("Separator", chr(9))
case 0 ' 0 of 0
