Csv Format

[BRRLL99]

Hi Team,

I have following data-set, I'm looking to save the data in CSV format

Data-set 

emp_id	emp_name	department_id	salary	manager_id
1	rahul	100	10000	4
2	ankit	100	15000	5
3	mohit	100	10000	4
4	vikas	100	5000	2
5	rohit	200	12000	6
6	sam	200	12000	2
7	rocky	200	9000	2
8	bhai	200	5000	2

Expected output:

when I created this using output tool; I'm receiving unexpected comma's in between columns

[Emmanuel_G · Accepted solution]

@BRRLL99 

Just specify \t as delimiters in line 3 of output tool as shown below.

By default, it's comma.

Le me kniw if it works as you want.

           

[grazitti_sapna · Accepted solution]

@BRRLL99 , The csv file denotes Comma Separated Values so the file which is saved as csv is always comma separated. If you want any other separator you will have to explicitly specify it in your Output tool.