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.
delimited by commas
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.
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.
Export the MS Works database file in a comma-delimited format, save the file, then import the file into MS Excel.
A list of words separated by commas is called a "comma-separated list" or a "comma-delimited list."
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.
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."
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
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.
yes it is
Excel does not use format symbols.
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