Create the comma delimited flat file

I am being asked to create a comma delimited flat file. This is the format for the file. It must include a carriage return line feed after every line:

Last Name,First Name,DOB (MM/DD/YYYY),Customer number

Running a separate program against the file, the report will populate the entries.
Using Excel, should I put an entry into into each field with the comma (Last Name,) or does the separated field create it's own comma?

Thanks
bizzie247Asked:
Who is Participating?
 
TazDevil1674Commented:
Excel adds a comma (or whatever you specify) to denote a change in column.  ie  If you have data in Columns A & C you would get an output like:

Surname,,Firstname

Hope this helps
0
 
telyni19Commented:
You can save a file as CSV directly from Excel, which will automatically comma-delimit the data. When you open a CSV in Excel, you won't see the commas: Excel will display the data in separate columns automatically. But if you open the CSV in a text editor, you'll see the commas.
0
 
bizzie247Author Commented:
Thanks, I believe I have it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.