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
