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

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.