0

I have a excel file (.XLSX/.CSV/UTF-8) etc with 1390 lines however I am getting an issue with CSVLint stating that I have inconsistent line breaks I note in the spreadsheet it is using a lot of accents on words punctuation marks etc.

How could I alter this file so it will be valid and import correctly?

Jess McKenzie
  • 8,345
  • 27
  • 100
  • 170
  • XLSX and CSV are two completely different files. I can't find doc explaining "inconsistent line breaks" but I guess it means there are a mix of CRLF and just CR – Nick.Mc Aug 20 '21 at 05:17
  • @Nick.McDermaid Thats what it is - I am looking for a way to straighten them all out as CRLF – Jess McKenzie Aug 20 '21 at 05:20
  • Use as RegEx Find/Replace tool to replace CR^[LF] with CRLF. You'll also need a capture in the regex to not overwrite whatever follows CR. What are your options for running an external tool / script? – Nick.Mc Aug 20 '21 at 05:25
  • Something like this https://stackoverflow.com/questions/9294779/how-to-fix-inconsistent-line-endings-for-whole-vs-solution – Nick.Mc Aug 20 '21 at 05:26
  • @Nick.McDermaid Can you run me through how to do this plz, No options open to anything :) – Jess McKenzie Aug 20 '21 at 05:26
  • I have no idea what you can and can't do. Try googling "fix inconsistent line endings" and find a solution that appeals to you. For example are you happy with a manual process? – Nick.Mc Aug 20 '21 at 05:29

0 Answers0