topic RE: File exists not working if file name is defined within a data item in Product Forum

File exists not working if file name is defined within a data item

JanetPannone — Mon, 15 Jul 2019 12:00:00 GMT

Using VBO Utility - File Management File Exists to check if the file exists with the input File Name value set to a data item with an initial value of the full path to the file returns false.

If I change the value to be the full path the file is found.

Is this a know problem?

------------------------------
Janet Pannone
Programmer
DXC
America/New_York
------------------------------

RE: File exists not working if file name is defined within a data item

david.l.morris — Mon, 15 Jul 2019 12:07:00 GMT

Can you verify what is in the data item [fileNm]? There should be no difference between passing it in a data item and passing it as a string literal in the input.

Data Item Value should be like this with no quotes: C:\Users\default\Documents\PerformanceTimings.xlsx

If you put it in the input directly then it looks like this: "C:\Users\default\Documents\PerformanceTimings.xlsx"

And if you use the Data Item instead then like this, just as you have: [fileNm]

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: File exists not working if file name is defined within a data item

JanetPannone — Mon, 15 Jul 2019 12:17:00 GMT

Thank you. I had quotes on the data item. Works perfectly now that they have been removed.

------------------------------
Janet Pannone
Programmer
DXC
America/New_York
------------------------------