topic Re: what is meant by csv file format in Application Development and Automation Discussions

what is meant by csv file format

Former Member — Mon, 10 Mar 2008 05:50:05 GMT

what is meant by csv file format

Re: what is meant by csv file format

Former Member — Mon, 10 Mar 2008 05:53:37 GMT

Hi,

csv:- Means Comma Separated values.

When we are using BDC some times we will take this file type .This file will have values which are separated by comma.

Ex: 'Ab0000',01023,'fhfhfhf'.

Re: what is meant by csv file format

Former Member — Mon, 10 Mar 2008 05:54:01 GMT

it is a comma sepaterd values.

it is similar to a txt file where each value is sepaterd from other by comma. when you exprt it to data base say access it will directly split the column valyues as per comma.

so comma acts as a delimeter here.

you can also save a excel (in save as select file type as csv) as csv and see the result how it saves.

please reward if useful.

Re: what is meant by csv file format

Former Member — Mon, 10 Mar 2008 05:55:10 GMT

hi,

A comma delimited file is a database exported into a format where each record is a single line and each field in the record is indicated by a comma. Where necessary (e.g., if the field has a comma in it) the field will also be quoted. If you have Excel, use the import feature of Excel to import the file. Specify comma delimited format as the import format. Then export to whatever format you require for the data.

You can also usually import this format directly into most any database program or spreadsheet program as well. This file type is often associated with Microsoft Excel as this is one of the standard ways to transfer data into and out of a spreadsheet

CSV stands for Comma Separated Values, sometimes also called Comma Delimited. A CSV file is a specially formatted plain text file which stores spreadsheet or basic database-style information in a very simple format, with one record on each line, and each field within that record separated by a comma. It's important that the individual "records" within a CSV file NOT contain commas, as this may break the simple formatting when using the file in another application.

CSV files are often used as a simple way to transfer a large volume of spreadsheet or database information between programs, without worring about special file types. For example, transferring a home-made address book from Excel into a database program such as Filemaker Pro could be done by exporting the file as a CSV from Excel, then importing that CSV into Filemaker.

Creating a CSV file from spreadsheet data is very simple to do using Microsoft Excel.

Open your spreadsheet document and go to the File pull-down menu, then choose Save As....

Change the "Save as type" or "Format" field to read: "CSV (Comma delimited)".

Enter a name for the document and click Save.

To check the validity of your CSV file, open the new file from a plain-text reading program such as Notepad or TextEdit. Check to make sure there are no extra commas, other than between fields. Depending on what program you're going to use the CSV file with, you may need to also remove any extra quotation marks or other formatting which Excel may have inserted.

Hope this helps, Do reward.

Edited by: Runal Singh on Mar 10, 2008 11:25 AM

Re: what is meant by csv file format

vinod_vemuru2 — Mon, 10 Mar 2008 05:55:38 GMT

Hi,

CSV file is nothing but an Excell file but

with comma delimited. When u upload a csv file to an internal table u can see the data in each column seperates by comma(,). U can try a sample program using FM GUI_UPLOAD.

Thanks,

Vinod.