AWS Glue crawler detecting a .(dot) before header of a csv file

Question

I am trying to crawl a csv file in utf-8 encoding format but the crawler is detecting a dot before the header. I cannot see any dot when i open the file in text or excel.

Edited by: kmn on Jan 30, 2019 6:54 AM  
  
Edited by: kmn on Jan 30, 2019 6:55 AM

fabioSama · Answer

That looks more like a white space to me. You sure there's no space in there?

kmn · Answer

No. There is no white space, this issue only happens when the file is encoded to utf-8

kmn · Answer

This issue arise because of how i saved the csv in utf-8 from excel.   
I now open the file in notepad and save it as utf-8 which helped fixing this.

AWS Glue crawler detecting a .(dot) before header of a csv file

Füge deine Antwort hinzu

Relevanter Inhalt