answersLogoWhite

0

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

15y ago

What else can I help you with?

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 are delimited records?

Delimited records refer to a format in which individual data entries are separated by specific characters, known as delimiters. Common delimiters include commas, tabs, or semicolons, allowing for easy parsing and interpretation of the data. This format is widely used in data files like CSV (Comma-Separated Values) or TSV (Tab-Separated Values), facilitating the organization and manipulation of structured information. Delimited records enable efficient data exchange between different systems and applications.


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.


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 is the difference between Formatted Text and Comma delimited?

In a comma delimited file, data is stored as free-form text with each value separated by a comma. Text data may or may not be quoted and numbers appear with signs and decimals as appropriate. Example: "my data", 1, 2.5, 3 A fixed format file stores each value in a fixed position in the record. There are no delimiters in the record and you must know the format of the record and fields to properly interpret the information. Numeric fields usually do not contain decimal points (decimal position is implied by the column format) and the sign may be in a leading position or trailing position, or it may be 'zoned', meaning the sign is indicated by altering the lead bit in either the leading or trailing character. Negative digits would appear as a letter. In the above example, if it was fixed format with 4 fields with the first being text of 10 characters followed by 3 numbers with 6 digits with 2 implied decimal places (i.e. 9999.99) the data would appear as: my data 000100000250000300