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

BULK LEADS EXTRACT

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

2 replies

New Participant
February 4, 2020
No text available
Translate
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.

Translate