We recently encountered some differences between csv files uploaded manually to S3 via Console vs. programmatically upload csv file. We noticed that the manually uploaded file (from console) had added double quotes, meanwhile the programmatically upload file does not. For example:

Manual Upload (Console):
"ID"|"TYPE"|"DATE"
"123456 "|"B "|"2021-12-06 "

Programmatic Upload:
ID|TYPE|DATE
123456 |B |2021-12-06

The intention is that we'd programmatically upload files in production so we'd likely only encounter this difference in development account. But, I'd like to understand why this is the case?

CodePudding user response：

There must be something in your environment as uploading a file via the AWS Management Console does not modify the file content. I copied your content and uploaded via the Console. When i downloaded and opened the file, it was the same as shown here: