How to comma seprate csv but not all cells

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

How to comma seprate csv but not all cells

buran

Posts: 8,091

Threads: 154

Joined: Sep 2016

Reputation: 582

Aug-24-2018, 06:33 AM

try to use csv module, don't split at commas on line 6. I guess the csv file is properly formated, then property type columns is double quoted because there is comma in the value and csv module will process it correctly

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Find

Messages In This Thread

How to comma seprate csv but not all cells - by Prince_Bhatia - Aug-24-2018, 06:18 AM

RE: How to comma seprate csv but not all cells - by buran - Aug-24-2018, 06:33 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	[SOLVED] [BeautifulSoup] Turn select() into comma-separated string?	Winfried	0	1,146	Aug-19-2022, 08:07 PM Last Post: Winfried
	How to format Excel column with comma?	dee	0	1,401	Jun-13-2022, 10:11 PM Last Post: dee
	Openpyxl-change value of cells in column based on value that currently occupies cells	phillipaj1391	5	9,986	Mar-30-2022, 11:05 PM Last Post: Pedroski55
	decimal comma	DPaul	9	2,342	Feb-22-2022, 12:25 PM Last Post: DeaD_EyE
	Adding a comma in the resulting value	stsxbel	6	2,705	May-22-2021, 09:24 PM Last Post: stsxbel
	How can I iterate through all cells in a column (with merge cells) with openpyxl?	aquerci	1	7,568	Feb-11-2021, 09:31 PM Last Post: nilamo
	How to instantly add quotation marks and comma for parameters?	cheers100	4	8,207	Oct-22-2020, 12:51 PM Last Post: cheers100
	print scripts example includes comma that seems to serve no purpose	flour_power_33	5	2,856	Sep-02-2020, 03:32 AM Last Post: flour_power_33
	Copy certain cells into new workbook certain cells	Kristenl2784	4	2,523	Jul-14-2020, 07:59 PM Last Post: Kristenl2784
	Grabbing comma separed values from SQLite and putting them in a list	PythonNPC	8	4,148	Apr-10-2020, 02:39 PM Last Post: buran

Users browsing this thread: 1 Guest(s)

View a Printable Version

How to comma seprate csv but not all cells

User Panel Messages

Announcements