[ferret_users] CSV file with commas in string fields

To: ferret <ferret_users@xxxxxxxx>
Subject: [ferret_users] CSV file with commas in string fields
From: Marco van Hulten <Marco.Hulten@xxxxxx>
Date: Fri, 4 Sep 2020 16:33:22 +0200
List-archive: <https://groups.google.com/a/noaa.gov/group/ferret_users/>
List-help: <https://support.google.com/a/noaa.gov/bin/topic.py?topic=25838>, <mailto:ferret_users+help@noaa.gov>
List-id: <ferret_users.noaa.gov>
List-post: <https://groups.google.com/a/noaa.gov/group/ferret_users/post>, <mailto:ferret_users@noaa.gov>
Mailing-list: list ferret_users@xxxxxxxx; contact ferret_users+owners@xxxxxxxx
Organization: University of Bergen
Sender: owner-ferret_users@xxxxxxxx

Hello,
 
I load CSV files that sometimes have commas in some string fields.
According to, for instance, RFC 4180, at least the string fields with
commas should be surrounded by double-quotes, so, for instance:
 
"st1",2,3
"st1,2",2,3
st2,2,3
 
This fails when trying to load with COLUMNS: the comma between
double-quotes is treated as a field-separator.
 
Two options are (1) using a different field separator (e.g. the tab
character) and (2) remove/replace the commas, but I prefer to avoid
reformatting of the CSV data.
 
Any additional ideas?
 
—Marco

Follow-Ups:
- Re: [ferret_users] CSV file with commas in string fields
  - From: Ryo Furue

Previous by thread: [ferret_users] strange behavior using @DIN for vertical pressure levels
Next by thread: Re: [ferret_users] CSV file with commas in string fields

[Thread Prev][Thread Next][Index]