We have a list of file paths and short file names in our database.
We need to loop through them all, picking up the long file name from the
file itself and check that the long file name does not include a "~"
I have the short file name and path in a variable (eg
"c:\data\123442~1.doc") how can I get the long file name from this data.
Any advice would be much appreciated.