cancel
Showing results for 
Search instead for 
Did you mean: 

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

JanetPannone
Level 2
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.   
15897.png
If I change the value to be the full path the file is found.
15898.pngIs this a know problem?


------------------------------
Janet Pannone
Programmer
DXC
America/New_York
------------------------------
1 BEST ANSWER

Best Answers

DaveMorris
Level 14
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
------------------------------
Dave Morris 3Ci at Southern Company Atlanta, GA

View answer in original post

2 REPLIES 2

DaveMorris
Level 14
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
------------------------------
Dave Morris 3Ci at Southern Company Atlanta, GA

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

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