Is there a way to include commas in CSV columns without brea

View unanswered posts | View active topics

Board index » General » General Discussion

All times are UTC - 5 hours

Moderator: General Moderators

Page 1 of 1

[ 5 posts ]

Print view

Previous topic | Next topic

Author

Message

vinodkumar

Post subject: Is there a way to include commas in CSV columns without brea

Posted: Thu Aug 21, 2014 8:11 am

Forum Newbie

Joined: Thu May 29, 2014 12:15 am
Posts: 4

Is there any way to put commas in csv file.

I've got a two column CSV with a name and a number. Some people's name use commas, for example "Joe Blow, CFA." This comma breaks the entire CSV format.
How to handle this type of cases?Any alternative is there? Please let me know.

Top

Celauran

Post subject: Re: Is there a way to include commas in CSV columns without

Posted: Thu Aug 21, 2014 8:19 am

Moderator

Joined: Tue Nov 09, 2010 3:39 pm
Posts: 6425
Location: Montreal, Canada

Moved because this has nothing to do with Linux.

Wrapping your columns in quotes should prevent problems caused by commas in your values. You could also use a different separator.

_________________

Top

pickle

Post subject: Re: Is there a way to include commas in CSV columns without

Posted: Fri Aug 22, 2014 10:24 am

Briney Mod

Joined: Mon Jan 19, 2004 7:11 pm
Posts: 6446
Location: 53.01N x 112.48W

Re: escaping: The standardized practice is to escape double quotes with double-double quotes:

42,"Joe ""The Blowman"" Blow, CFA.",100.0

http://www.ietf.org/rfc/rfc4180.txt, search for "double quotes"

_________________
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.

Top

requinix

Post subject: Re: Is there a way to include commas in CSV columns without

Posted: Fri Aug 22, 2014 12:31 pm

Spammer :|

Joined: Wed Oct 15, 2008 2:35 am
Posts: 6617
Location: WA, USA

If you're writing the CSV using PHP then use , which will deal with the quote thing for you.

Top

Tayla6

Post subject: Re: Is there a way to include commas in CSV columns without

Posted: Fri Aug 29, 2014 8:07 am

Forum Commoner

Joined: Thu Oct 10, 2013 8:40 am
Posts: 26
Location: Manchester

I am not sure if there is any way to use commas in a csv file.

_________________
Tayla the great

Top

Page 1 of 1

[ 5 posts ]

Board index » General » General Discussion

All times are UTC - 5 hours

Who is online

Users browsing this forum: No registered users and 9 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to: