Comma Delimitation

In a comma delimited text file, the individual fields are separated by commas. An example of a comma delimited file would look like this:

0543166,Oranges,Perishable
17890,Flower Pots,Breakable
1203768,Apples,Perishable
1029384,Bananas,Perishable

Since there are four lines in the file, four different items with three different types of data would be printed.

There is a space in the second field of the second line between the word "Flower" and the word "Pots". Comma delimitation recognizes spaces as long as they are embedded in between the data characters in a field. However, when the data for an individual field includes "leading" or "trailing" spaces that you wish to print, you must use quote and comma delimitation. Comma delimitation will automatically strip all leading and trailing spaces.

Related Topics