Hi Mike,

 

thanks for reaching out.

Could you please share with us the file you are trying to upload?

 

Best Regards,

Blenda

---

Hi Mike,

 

thanks for reaching out.

Could you please share with us the file you are trying to upload?

 

Best Regards,

Blenda

Please find attached the file that i was trying to upload. Would appreciate any help.

Best regards

---

Hi Mike,

Can you please check line ending characters and if string fields have the same character used for delimiting?
Line ending characters are control characters or a sequence of control characters in a character encoding specification that is used to signify the end of a line of text and the start of a new one, e.g., Line Feed in Unix.
Some text editors set this special character when pressing the ↵ Enter key. When displaying (or printing) a text file this control character or sequence of characters causes the text editor to show the characters following it in a new line.
For example: Columns A,B,C,D ',' Is the delimiter. this is the file (one row): text1,text2,test3,text4 .
If you have a line ending, will be like this:
text1,text2
,test3,text4

If you have a comma in the text, will be like this:
text1,text2,test,3,text4
and this will need one more additional column because of the additional comma, breaking the layout of ABCD columns but that row would need ABCDE.
You cannot really see the line ending character but you can check/change encoding using notepadd++ and you can also replace these control characters using regex, for example.

Please let me know if this helps or not.

Thanks and Best Regards,
Blenda

---