Forum Discussion

RobG's avatar
RobG
New Contributor
8 years ago

Spaces in File names or folder paths

I wonder if anyone has a resolution to my current challenge. I am a “newby” so please assume “I know nothing!”

I’m building some basic pipelines to connect to a xlsx.
If any folder in the path has a space or the filename itself has a space I am getting the following error…

Failure: Invalid URI, Reason: Illegal character in path at index 19: file:///T:/RobG/New Microsoft Excel Worksheet.xlsx, Resolution: Please make sure the URI file:///T:/RobG/New Microsoft Excel Worksheet.xlsx is correct.

When I introduce a space in the folder name it also fails…

Failure: Invalid URI, Reason: Illegal character in path at index 14: file:///T:/Rob G/NewMicrosoftExcelWorksheet.xlsx, Resolution: Please make sure the URI file:///T:/Rob G/NewMicrosoftExcelWorksheet.xlsx is correct.

Clearly the Resolution suggestion is not entirely helpful as we do have spaces and so the URI is correct…
Any help, gratefully received…
Rob