Input Tool Removes Leading Whitespace in FilePath

Question

Hi,

Is it possible to retain the whitespace in the filepath? Our file is saved in a directory folder which has a leading whitespace, but when we try to pull it in using an input tool, the whitespace is cleansed and the input tool errors out saying that it can't find the file.

For example:

Original FilePath: O:\Test Folder\ Test\Filename.csv

Input FilePath: O:\Test Folder\Test\Filename.csv

Thank you!

cynthiapan · Answer

No, we want to avoid manually/using a run command to change the directory name in the folders.

FreeRangeDingo · Answer

Is trimming the subject line an option to eliminate this problem?

cynthiapan · Answer

The folder was generated by the Alteryx Outlook 365 Tool because the subject line had a leading whitespace.