I have the following problem:
- I’m trying to get the filepath of the latest created file in a folder, using:
The formula works in the sense that it finds the latest file and it gives me the filepath. But, there is a small mistake in the filepath which makes that it doesn’t work.
Result as it SHOULD be:
As you can see, the first 2 characters of the filename are replaced by “~$”. This happens with xlsx, docx and ppt files. Pdf files on the other hand do not show this problem.
In the next activity, I use this filepath to copy the file to a new location. Right now, this results in a corrupted file.
Does anybody have an idea how to fix this?