0
What is the difference between Formatted Text and Comma delimited?
Wiki User
∙ 14y ago
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
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What does comma delimited mean in accounting?
delimited by commas
What is the difference between apostrophe and comma?
lotdgnv
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."
What is the difference between a comma modifier and a comma splice?
A comma splice is the attempt to join two independent clauses with a comma without a coordinating conjunction. For example, "She walked the dog last night, today she fed it."
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.
What is the difference between a run on and a comma splice?
A run-on sentence occurs when two independent clauses are connected without proper punctuation or conjunctions. A comma splice, on the other hand, happens when two independent clauses are incorrectly joined with a comma but without a coordinating conjunction. Both errors result in choppy or confusing sentences.
What is 'comma delimited format'?
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.
Difference between internation and national place value?
in international we have to put comma after 3 digits
What is the difference between one thousand and one thousandth?
The difference is one has a comma: One thousand, the other: One thousandth, has a decimal. Thank You!
What is the difference between coma and comma?
A coma is a state of prolonged unconsciousness, while a comma is a punctuation mark used to separate parts of a sentence.
What is the difference between a sentence and a run on?
A comma splice is when a two complete sentences are separated by a comma, without a conjunction. This makes it gramatically incorrect. A run-on sentence continues on and on with no clear predicate.
