Solved

Create the comma delimited flat file

Posted on 2013-06-21
3
483 Views
Last Modified: 2013-06-21
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
Comment
Question by:bizzie247
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 9

Accepted Solution

by:
TazDevil1674 earned 400 total points
ID: 39265847
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
 
LVL 12

Expert Comment

by:telyni19
ID: 39266079
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
 

Author Closing Comment

by:bizzie247
ID: 39266782
Thanks, I believe I have it.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question