Downloading a dataset as .CSV format

[sankar.guna]

Hi,

Can anyone tell me how to download a dataset into a .CSV format file ?
Thanks a lot.,

[arunprasad.k]

Just download the comma demilited file and rename it as SOME_NAME.CSV

Here are the few points to remember about comma demilited file.

#1 Each field should be seperated with a comma (you can use any symbol other symbol too). For example,

Code: Select all

Emp_ID,Emp_Name,Emp_Dept
12345,Sam,Healthcare
23456,Ram,Insurance
34567,Kumar,Retail

#2 If one of your fields already has ',' in it, then you have to be little careful and have to add double quotes to differentiate the delimiter. For example,

Code: Select all

"Emp_ID","Emp_Name","Emp_Dept"
"12345","Sam","Healthcare"
"23456","Ram","Insurance"
"34567","Kumar","Retail"

If this is not what you want, then post the requirements clearly.

Arun.

[dick scherrer]

Hello,

Can anyone tell me how to download a dataset into a .CSV format file ?

Downloading the file should not be a problem. Keep in mind that the download will not make csv data from plain text data - the mainframe process that creates the file must also create the delimiters.

If there is any chance that the data might contain commas as data, i'd suggest using a different delimiter. The tab character (x'05') works well. It you might have commas in the data and must use commas as the delimiters, then do as suggested and wrap each field in double quotes.