0

I am finding when loading csv's that if there is an empty field(s) then the data is moved from the next occupied field. For example:

enter image description here

No matter what I have tried the data gets shunted. Even when create a new file from scratch. I have not seen this behaviour in 5 years of QGIS use? This happens when using the standard csv file format import too. Just using the custom to show the preview. QGIS 3.28.2

enter image description here

enter image description here

Improve this question
6
  • 6
    Can you provide your csv with sample data? Maybe delimiters for empty fields are missing?
    – Babel
    Commented Jan 27, 2023 at 8:27
  • I could fill up all the empty spaces with 0 or N/A and it should prevent your data from moving.
    – Geographos
    Commented Jan 27, 2023 at 9:11
  • @Babel - sorry for the delay in response. I can't see how to add an attachment? in notepad++ the commas are definitely there.
    – famethrowa
    Commented Feb 20, 2023 at 3:03
  • @MKR - thanks but not really a long term sustainable solution
    – famethrowa
    Commented Feb 20, 2023 at 3:05
  • Expend the "Record and Fields Options" and made sure that the "Discard empty fields" is unckecked
    – J.R
    Commented Feb 20, 2023 at 11:01

1 Answer 1

Reset to default
1

As per J.R.'s suggestion, Expand the "Record and Fields Options" and made sure that the "Discard empty fields" is unckecked

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.