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)
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.
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
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
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?
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
