Csv Format

Question

Hi Team,

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

Data-set

emp_idemp_namedepartment_idsalarymanager_id1rahul1001000042ankit1001500053mohit1001000044vikas100500025rohit2001200066sam2001200027rocky200900028bhai20050002

Expected output:

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

Emmanuel_G · Accepted Answer

@BRRLL99

Just specify 	 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 Answer

@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.