DBADS
asked on
CSV vs Text delimited file
In the case where data files are required to be gathered from different sites, then uploaded into a SQL Server database, which is better to use and why? CSV files or Text delimited files (with a pipe delimiter for example)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
But in what way is the CSV better than text files?
Would you please specify cases where CSV was better than Text?
Would you please specify cases where CSV was better than Text?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
CSV is a text file, the reason they are useful is because they are easily imported into multi column formats such as spreadsheets and databases.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The extension is also not important. I often use .dat extension for my pipe delimited files.
Using text qualifiers doesn't always help in CSV (imagine i have a field which also contains those text qualifiers!
L
Using text qualifiers doesn't always help in CSV (imagine i have a field which also contains those text qualifiers!
L
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@dirkvdo: true- but you have to be careful opening the file with excel (it has a nasty habbit of "guessing" the file is .csv and automatically splitting columns. when you then do your "text-to-columns" operation your data gets a bit messed
but i expect we've covered what @sasi_kmr wanted to know :)
L
but i expect we've covered what @sasi_kmr wanted to know :)
L
ASKER
There was no decisive or recommended appraoch but the discussion is rich enough
text files are not convenient to work with.
thanks.
$a$i