Editing Delimiter (section)

====ASCII delimited text====
The ASCII and Unicode character sets were designed to solve this problem by the provision of non-printing characters that can be used as delimiters. These are the range from ASCII 28 to 31.

{| class="wikitable"
|-
! ASCII [[Decimal|Dec]]
! Symbol
! Unicode Name
! Common Name
! Usage
|-
! 28
! {{resize|200%|␜}}
| INFORMATION SEPARATOR FOUR
| [[file separator]]
| End of file. Or between a concatenation of what might otherwise be separate files.
|-
! 29
! {{resize|200%|␝}}
| INFORMATION SEPARATOR THREE
| [[group separator]]
| Between sections of data. Not needed in simple data files.
|-
! 30
! {{resize|200%|␞}}
| INFORMATION SEPARATOR TWO
| [[record separator]]
| End of a record or row.
|-
! 31
! {{resize|200%|␟}}
| INFORMATION SEPARATOR ONE
| [[unit separator]]
| Between fields of a record, or members of a row.
|}

The use of ASCII 31 [[Unit separator]] as a field separator and ASCII 30 [[Record separator]] solves the problem of both field and record delimiters that appear in a text data stream.<ref>[http://ronaldduncan.wordpress.com/2009/10/31/text-file-formats-ascii-delimited-text-not-csv-or-tab-delimited-text/ Discussion on ASCII Delimited Text vs CSV and Tab Delimited]</ref>