Unable to get a valid pathname from python os.path.abspath

Question

I have the following string containing absolute directory of a file.

'D:\Sample\Project\testXcl\data.xlsx'

On passing this into os.path.abspath, I am getting the following result:

'D:\\Sample\\Project\testXcl\\data.xlsx'

This happens because TestXcl folder name is read as \t. Wrong path/error also appears if any file/folder name is starting with n, a, b, f, r, v, x.

Is there any other method to rectify this, or should I go about replacing the string with correct file delimiters ?

+1 for researching spirit: you actually found the list of the escapable symbols :) — unkulunkulu, Jul 05 '12 at 08:31

phihag · Answer 1 · 2012-07-05T09:07:14.903

6

When you specify the path name, either escape the backslashes or use a raw string literal:

p = 'D:\\Sample\\Project\\testXcl\\data.xlsx'
p = r'D:\Sample\Project\testXcl\data.xlsx'

edited Jul 05 '12 at 09:07

answered Jul 05 '12 at 08:30

phihag

score 5 · Answer 2 · answered Jul 05 '12 at 08:30

5

Use a raw string literal instead.

filename = r'D:\Sample\Project\testXcl\data.xlsx'

answered Jul 05 '12 at 08:30

2 Answers2