How to allow a filename with whitespace in python?

Question

I have a script for importing the contents of csv files in to a database. But when I try

filepath = '/Users/mc_kaiser/Desktop/Foo\ 020218-021318.csv'
test = open(filepath)

I get an IOError:

IOError: [Errno 2] No such file or directory: '/Users/mc_kaiser/Desktop/Foo\\ 020218-021318.csv'

I looked at this SO post and tried some of the answers, but it's Windows specific and didn't answer my question. Thank you!

Did filepath = '/Users/mc_kaiser/Desktop/Foo 020218-021318.csv' not work? (Without the '\') — pault
– pault, Commented Feb 14, 2018 at 20:57

llllllllll · Accepted Answer · 2018-02-14 20:58:56Z

2

That \ for escape is only used by shell, not part of the file name. In Python, just use:

filepath = '/Users/mc_kaiser/Desktop/Foo 020218-021318.csv'

answered Feb 14, 2018 at 20:58

llllllllll

16.5k4 gold badges35 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1