cancel
Showing results for 
Search instead for 
Did you mean: 

Spaces in File names or folder paths

RobG
New Contributor

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

1 REPLY 1

del
Contributor III

If using the File Reader snap, try unchecking the Prevent URL encoding option.

image

Otherwise, if you must have it checked for a reason, try encoding it yourself with a “%20” replacing each space.