documentation for loadData should state that tab as a separator can be specified by "\t"
Description
documentation for loadData should state that tab can be specified by "\t"
if you actually have a tab between quotes, it re-interprets that to mean that you want a single space as your seperator so\ta file\twith\tcompound headers
gets parsed by " " <a tab between the ""> as "so\ta","file\twith\compound","headers" where as separator="\t" this gets parsed correctly"so","a file","with","compound headers"
Environment
sql server, csv, data load (not sure what to put here)
documentation for loadData should state that tab can be specified by "\t"
if you actually have a tab between quotes, it re-interprets that to mean that you want a single space as your seperator
so\ta file\twith\tcompound headers
gets parsed by " " <a tab between the ""> as
"so\ta","file\twith\compound","headers"
where as separator="\t"
this gets parsed correctly"so","a file","with","compound headers"