File jumbled in edit mode

Editor for simple (only one record type) Csv Files.

Status: Beta

Brought to you by: bruce_a_martin

File jumbled in edit mode

Forum: General Discussion

Created: 2020-10-26

Updated: 2020-10-28

malc - 2020-10-26

Hi, I'm trying to work with MoJ stats files from here

https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/888561/csvs-behind-data-tools-2-2019.zip

The one I'm trying to use is HO-code-principal-offence-2019.csv. This appear ok in the preview in file open but when I click edit the data in the columns is all jumbled

reCVSeditor2.png

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Bruce Martin - 2020-10-28

Change

the Tab to unicode

the Font to UTF-8

Last edit: Bruce Martin 2020-10-28

CsvParms-or8.png
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

malc - 2020-10-28

Thanks, that fixed it.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous