nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how can i work around path names in arcpy having spaces in them, if i can?

ronancorrigan

I'm trying to create an arcpy tool for one of the teams, and I have everything working. But when I redirect the path names to be where their data is saved and where they want the outputs to go to, I get errors like ERROR:00732 or ERROR:00210 and its because of the folder directories having spaces in their names. is there a work around for this? as getting the team to rename all their folders to exclude spaces isn't an easy sell

thanks lads and lasses

Find more posts tagged with

Accepted answers

All comments

JoshuaBixby

I agree with Dan's comments. Additionally, it helps to paste the exact error and traceback. I am also suspect of your location variable, what is stored in it?

DanPatterson_Retired

Ronan, it isn't just double quotes. It has to be 'raw' string encoded... ie with the 'r' in front.

The big problem right now, I suspect is that the path string gets corrupted from the get-go.

any folder that begins with a variety of characters is going to be messed up unless it is raw encoded.. or avoided by fixing your folders or using Herculean effort to correct them.

Did you read the link in my second post?

Filenames and file paths in Python

And to show that it works... change your folder for testing and/or to move you along

location <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\Junk"</SPAN>
r<SPAN class="string token">"{}\Testsheet.csv"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>location<SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">'C:\\Junk\\Testsheet.csv'</SPAN>

location <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\Junk and space"</SPAN>
r<SPAN class="string token">"{}\Testsheet.csv"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>location<SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">'C:\\Junk and space\\Testsheet.csv'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

ronancorrigan

I have been using double quotes the whole time but I still get an error

below is an example fo what i'm doing;

arcpy.CopyRows_management(excelscript, r"{}\Testsheet.csv".format(location))
pfc_temp = r"{}\Testsheet.csv".format(location)

where location is a folder parameter. if I just set location to the folder in question directly it still comes up with the same error

DanPatterson_Retired

we failed to add the multiplatform solution... /

path = "C:/tmp/folder with spaces/user.me space"

JoshuaBixby

I agree with Dan that spaces, commas, period, etc... in path names isn't a great idea, it raises the risk that some program will get tripped up when working with files and folders. That said, many of those characters are not forbidden in ArcGIS paths. If you start working with Python's os.path module and using raw strings, you should be fine:

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> path <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\tmp\folder with spaces\user.me space"</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> path
<SPAN class="string token">'C:\\tmp\\folder with spaces\\user.me space'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">)</SPAN>
<SPAN class="token boolean">True</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> res <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CreateFileGDB_management<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"fgdb"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> arcpy<SPAN class="punctuation token">.</SPAN>CreateTable_management<SPAN class="punctuation token">(</SPAN>res<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"tbl"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token"><</SPAN>Result <SPAN class="string token">'C:\\tmp\\folder with spaces\\user.me space\\fgdb.gdb\\tbl'</SPAN><SPAN class="operator token">></SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

share this

/blogs/dan_patterson/2016/08/14/filenames-and-file-paths-in-python

even Microsoft doesn't recommend spaces and other flotsam in filenames or paths.

I bet the team has a space or a period in their 'User' profile too. Caused us headaches for a while until IT and us got things straightened out

DanPatterson_Retired

pth <SPAN class="operator token">=</SPAN> <SPAN class="string token">"c:\the path\with\a\space\in\its\name"</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>pth<SPAN class="punctuation token">)</SPAN>
c<SPAN class="punctuation token">:</SPAN>      he path\<SPAN class="keyword token">with</SPAN>\space\<SPAN class="keyword token">in</SPAN>\its
ame

pth <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"c:\the path\with\a\space\in\its\name"</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>pth<SPAN class="punctuation token">)</SPAN>
c<SPAN class="punctuation token">:</SPAN>\the path\<SPAN class="keyword token">with</SPAN>\a\space\<SPAN class="keyword token">in</SPAN>\its\name<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

it isn't just spaces, any of a number of letters that follow the \ cause problems...

I have identified a few.

note the little 'r' before the path name? that is called 'raw' encoding.

it is one of just many options.

since they won't get the smarts you will have to ensure that you do it for them

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.