topic Re: Python csv.writer delimiter with \ ? in Python Questions

Python csv.writer delimiter with \ ?

DevinUnderwood2 — Thu, 21 Jul 2016 19:39:26 GMT

How do I use a back slash as a delimiter, python wont recognize it.

ofile = open('MapServicesInfo.csv', "w")

writer = csv.writer(ofile, delimiter = '\', quotechar='"', quoting=csv.QUOTE_ALL)

Re: Python csv.writer delimiter with \ ?

WesMiller — Thu, 21 Jul 2016 20:30:53 GMT

In python a backslash is an escape character. I don't think you'll be able to use for a csv. Have you tried using 2 \\ or a forward / slash?

Re: Python csv.writer delimiter with \ ?

DevinUnderwood2 — Thu, 21 Jul 2016 20:37:10 GMT

This is an example of a row I need to write to csv file by delimiting the slash.

Write each section within the slashes to separate rows .

I guess I need to know how to make it not recognize as a escape character ?

... \Sewer\ControlValve

Re: Python csv.writer delimiter with \ ?

DanPatterson_Retired — Sat, 11 Dec 2021 14:40:48 GMT

Here is the process

>>> a = "Sewer\ControlValve"
>>> b = a.split("\\")
>>> b
['Sewer', 'ControlValve']
>>> c = ("{}\n"*len(b)).format(*b)
>>> c
'Sewer\nControlValve\n'
>>> print(c)
Sewer
ControlValve

Now that can be simplified of course

Re: Python csv.writer delimiter with \ ?

DevinUnderwood2 — Thu, 21 Jul 2016 21:13:03 GMT

Interesting I just added .split ("\\)

writer.writerow([fullpath.split("\\")])

I get the following which correctly splits it at the slashes and yields commas.

['Sewer', 'ControlValve']

So, I only need to write to different rows where it is has a comma.

Re: Python csv.writer delimiter with \ ?

DanPatterson_Retired — Thu, 21 Jul 2016 21:28:56 GMT

I handled that in my example

see line 5

if you have to do this, all it does is determine the length of the list (hence the len(b)) and multiplies the format designator {} the correct number of times, then adds a newline

hence.... line 5

this is equivalent to

use my c syntax

for i in c:

writer.writerow(i)

and you are done

Re: Python csv.writer delimiter with \ ?

DevinUnderwood2 — Thu, 21 Jul 2016 22:19:39 GMT

Thanks for the help

I put the following and results in vertical rather than horizontal and each letter is written to a different cell.

b = fullpath.split("\\")

c = ("{}\n" * len(b)).format(*b)

for i in c:

writer.writerow (i )

Re: Python csv.writer delimiter with \ ?

DanPatterson_Retired — Thu, 21 Jul 2016 22:26:31 GMT

simpler still... use b if you have to write one row at a time

for i in b: print(i)

...

Sewer

ControlValve

Re: Python csv.writer delimiter with \ ?

DevinUnderwood2 — Thu, 21 Jul 2016 22:37:21 GMT

b = fullpath.split('\\')

c = ("{}\n" * len(b)).format(*b)

for i in b:

writer.writerow(i)

This is one step closer. Yet writing into single cells and vertically.

S\"E"\"W"...

C\"O"\"N"...

Re: Python csv.writer delimiter with \ ?

DanPatterson_Retired — Thu, 21 Jul 2016 22:39:57 GMT

grief... it obviously don't write the newline

so try to add it

writer.writerow( i + "\n" )

Re: Python csv.writer delimiter with \ ?

DanPatterson_Retired — Thu, 21 Jul 2016 22:42:23 GMT

there is something wrong with the example you gave me, since it shouldn't be splitting things out letter by letter. it should just split on "\\"

You had better do a test on that to see if it works with your inputs

I would convert fullpath to a string first, then post that example since there is something amiss in my examples and your inputs.