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 a run on and a comma splice?
The difference between a run on and a comma splice is that a run on just keeps going and a comma splice is when you use a comma incorrectly
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."
Can you use a semicolon instead of a comma in a a list?
If the list of phrases contains commas, the list is properly delimited by using semicolons.
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.
Difference between internation and national place value?
in international we have to put comma after 3 digits
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.
What is the difference between a comma and a hyphen?
A comma looks like this , a comma separates phrases or connects two or more sentences. A hyphen looks like this - a hyphen connects words or parts of words to make a new word.
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!
