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

0

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.
https://imgur.com/b5Rfhfk

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

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

kmn
asked 5 years ago216 views
3 Answers
0

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

answered 5 years ago
0

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

kmn
answered 5 years ago
0

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.

kmn
answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions