Unable to Open File for Read

Question

Hi Guys,

I would like to ask for your assistance about how to fix "Unable to Open File for Read" in the shared drive. I check the drive and there is no temporary file on it. The workflow goal is to read the files and filtered the current files (whose filename has a date).

If there are any easy to do it. Please also advised. Looking forward for your prompt response.

Thank,

Kamen

AAJOHN · Answer

Try using a filter after the formula for the full path to exclude "~$" in the file name. In the filter, select --> File name --> does not contain --> ~$.

KamenRider · Answer

hi @jbravman_

Tried dragging without the macro into the canvas and it seems fine.

Change the data length to 9000 and still with macro, same error encountered.

Check the files by opening in the notepad ++ and all seems to be fine. No error encountered.

I can't understand about the delimiter you have mentioned. can you provide me screenshot on how to locate and do it?

So far same error encountered "Unable to open file for read"

Can you please or anyone help me resolve this issue?

Thanks,

Kamen

jbravman_ · Answer

First try dragging the file into the canvas (alone, no macros). See what it says.

First try changing the data length from default 254 to something big like 9000. See if that works

if it doesnt

Try changing the delimiter from the default , (comma) to \0 (slash zero), toggle #6 in the config (no checkmark) and set the length to 9000 or a big number again.  See if you can read it in.

If you can do the latter then you will need to do the data parsing outside the input tool

Also make sure the file isn't corrupt, see if you can open it in a notepad or notepad++