BULK LEADS EXTRACT | Community
Skip to main content
Level 1
May 23, 2019
New

BULK LEADS EXTRACT

  • May 23, 2019
  • 2 replies
  • 1219 views

CSV形式でデータを抽出した場合、先頭行にのみ「”(ダブルクオーテーション)」が付与され、他の列には「”(ダブルクオーテーション)」が付与されていない。CSVデータを弊社DBに取り込む際、取り込み失敗を避けるため、全てのカラムに「”(ダブルクオーテーション)」が入っているデータで取得したい。

2 replies

SanfordWhiteman
Level 10
May 23, 2019

Double quotes should only appear where necessary. They're only necessary if the value also contains a double quote or a comma. If the value doesn't contain either of these characters, the quotes are optional.

If you are not seeing double quotes where they are necessary to quote the special characters, that is a bug.

But if they are not necessary, any import process should understand the format.

February 4, 2020
No text available