Hello Jim,
I predicted to myself that the files would work immediately for you. If they hadn’t, it would mean there was an obvious and blatant error in Pan X code, and I knew for sure you would not have released such a program.
The recorded code in my database runs the first time through, but results in a blank Error Wizard window every time thereafter. So that’s why that is not a viable solution.
However, I have a workaround.
The code below DOES NOT work, and gives the “file not found” error:
importtext binarytotext(fileload(“/Users/vicdifranco/Data/Financial/
Investment Folder/Portfolio.txt”)),“ExistingData”,“Replace”,
“AddFields”,“No”,“ReArrange”, “”+tab()+import()
The following code DOES work - first time, and every time. Note the fileload( function is exactly the same as before (copied and pasted):
Local myData
let myData = binarytotext(fileload(“/Users/vicdifranco/Data/Financial/Investment Folder/Portfolio.txt”))
ARRAYFILTER myData, myData, ¶, “”+tab()+import()
openfile “&@myData”
Apparently, Pan X is more comfortable manipulating text arrays than manipulating text files. The second macro code is not as elegant or concise as the first, but it is not unwieldy or difficult to understand.
Perhaps this simple workaround will help someone else who experiences a similar issue. At any rate, it suggests there is a subtle and non-replicable error in the importtext ReArrange option.
Many thanks to all who helped with this problem. What a great forum this is!
Best regards,
Vic