answersLogoWhite

0

What is 'comma delimited format'?

Updated: 12/24/2022
User Avatar

Wiki User

14y ago

Best Answer

Also referred to as comma-separated format (CSV), this format is a way to store data by separating each field with a comma.

EXAMPLE: first item, second item, third item, fourth item, fifth item, etc.

Other delimited formats can use other characters as a delimiter to identify the difference between each field in a collection of data (database).

OTHER EXAMPLES:

"first item" "second item" "third item" "fourth item" "fifth item", etc.

first item; second item; third item; fourth item; fifth item; etc.

first_item second_item third_item fourth_item fifth_item, etc.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is 'comma delimited format'?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What does comma delimited mean in accounting?

delimited by commas


What is tilde delimited?

The term tilde-delimited is used to described a file or data format. Tilde is actually a key symbolized by ~. When someone wants to pass some information such as a 'data file', they can send the data in various formats, such as 'csv' (comma separated values), 'tilde-delimited' etc The advantage with using tilde-delimited format is that it avoid any calculation or reporting related error for numeral values. example: a CSV file for a numbers that already have a format will result in an error in data reporting because the commas used in formatting and in numbers can not be easily differentiated. Usage of 'tilde-delimited' format avoids such data misinterpretation and hence, is a preferred way of data format requests.


How do you export data from a Dos ver 5 database to Excel?

A good way is to export from a database is to save as CSV format (or some sort of comma-delimited text format), then open Excel and import the file into Excel.


How do you convert a ms Works database file to a Microsoft Excel file?

Export the MS Works database file in a comma-delimited format, save the file, then import the file into MS Excel.


What is it called to have a list of words separated by commas?

A list of words separated by commas is called a "comma-separated list" or a "comma-delimited list."


How do you convert a comma delimited file to an excel file?

Click Open (or CTRL-O). Under file type, select text files. Select the file you want to convert. You will automatically get a "wizard" asking if the columns are delimited or fixed-width, as well as at which line to start conversion, what delimiter(s) to recognize, the format of each column, etc.


Can you use a semicolon instead of a comma in a a list?

Yes, a semicolon can be used to separate items in a list when the items themselves contain commas. For example: "I have visited Paris, France; Rome, Italy; and Barcelona, Spain."


What is csvbridge?

Csvbridge is is a Java utility that allows you to import and export comma-delimited data (csv files) to and from a PostgreSQL database. license: GPL


What is a delimiter in Linux?

A delimiter is simply some character or other token that is there to show where one item in a list ends and another begins. Think about CSV, which is comma seperated values, aka comma DELIMITED values.


Is a comma a valid format symbol in Microsoft Excel?

yes it is


What are valid format symbols in Excel?

Excel does not use format symbols.


What effect does the comma style format have on the selected cells for Excel?

The comma style will format numbers with two decimal places and insert commas as thousand separators. So if you had a number like 3455679 in a cell and formatted it as comma style, it would come up as:3,455,679.00