Example CSV File Format

SCALE,2000000,,,,,
TRANDATE,20/04/00,,,,,
PROJECTION,27700,,,,,
COLTYPE,UCODE,FNAME,FTYPE,DATE,POINT,POINT
COLSUBTYPE,NAME,NAME,NAME,,X,Y
VALUE,PORT_1,ST.MARY'S SCILLY ISLES,PORT,01/01/00,90182,10838
VALUE,PORT_2,PENZANCE (NEWLYN),PORT,01/01/00,146163,28319
VALUE,PORT_2A,PORTHLEVEN,PORT,01/01/00,162761,25699
VALUE,PORT_3,LIZARD POINT,PORT,01/01/00,170470,10516
VALUE,PORT_4,COVERACK,PORT,01/01/00,179143,17574
VALUE,PORT_4A,HELFORD RIVER (ENTRANCE),PORT,01/01/00,179449,24984
VALUE,PORT_5,FALMOUTH,PORT,01/01/00,182135,32296
VALUE,PORT_5A,TRURO,PORT,01/01/00,182666,45263
VALUE,PORT_7,MEVAGISSEY,PORT,01/01/00,201665,44519
VALUE,PORT_7A,PAR,PORT,01/01/00,207939,53563
EOF,,,,,,

Note: The column separator, in this case a comma, is dependent on your regional settings on your PC. For example, German regional settings use a semi-colon (;) as the column separator. When transferring data between PCs with different regional settings it is therefore advisable to use a binary format such as Microsoft Excel and then re-export the data as CSV format on the new PC. Microsoft Excel will use the appropriate regional setting as the column separator.