BULK LEADS EXTRACT

0 Likes

BULK LEADS EXTRACT

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

2 Comments
SanfordWhiteman
Level 10 - Community Moderator

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.

kh-lschutte
Community Manager
Status changed to: Open Ideas