admin管理员组

文章数量:1391782

I'm using google.golang/api/bigquery/v2 package to import CSV files from GCS into BigQuery. The CSV file is using CRLF (\r\n) as the line separator.

Can BigQuery correctly parse CSV files that use CRLF (\r\n)?

I've searched the docs but couldn't find a clear statement about this.

I'm using google.golang./api/bigquery/v2 package to import CSV files from GCS into BigQuery. The CSV file is using CRLF (\r\n) as the line separator.

Can BigQuery correctly parse CSV files that use CRLF (\r\n)?

I've searched the docs but couldn't find a clear statement about this.

Share Improve this question edited Mar 12 at 9:16 Tri Pham asked Mar 12 at 9:14 Tri PhamTri Pham 255 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 1

\r\n should be just fine.

BQ doc refers to RFC 4180, which says:

  1. Each record is located on a separate line, delimited by a line break (CRLF).

The document in turn refers to RFC 2234, which defines:

CRLF = CR LF ; Internet standard newline

本文标签: goDoes BigQuery support CSV files with CRLF (rn) line endingsStack Overflow