Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

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
0
bizzie247
Asked:
bizzie247
1 Solution
 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now