[Dx4win] Need tips how to clean up garbled .csv file

Dick Flanagan dick at twohams.com
Fri Oct 20 22:29:09 EDT 2006


At 07:11 PM 10/20/2006, Rick Murphy wrote:
 >On 10/20/06, Dick Flanagan <dick at twohams.com> wrote:
 >> You betcha!  .csv files are "comma-delimited" and the application uses
 >> commas to determine when one field ends and the next one begins.  If you
 >> have commas in data fields, the system loses track and all subsequent
 >> fields are thrown off.
 >
 >Not quite. CSV files can have arbitrary text when strings are quoted
 >with "....".

Quite true.  Remove the commas or place quotes around the offending Comments.

73, Dick
--
Dick Flanagan K7VC NV SM
E-mail: k7vc at arrl.org



More information about the Dx4win mailing list