I’m not certain this is related, but I may have another piece to this problem. I’m not certain mine is related, but I’m getting the same error regarding import(). Nothing else here or on BitBucket seems to fit and #567 remains unresolved.
importtext fileload(iFile), "REARRANGE",import()
gives me the runtime error “No value for import( function.”
iFile is a crlf delimited file from Windows with fixed text length fields which can include commas. Without the REARRANGE iFile imports as expected; the commas split fields where they fall. In Pan6 I handled this with
strip(import()[1,Whatever])+tab()+strip(import()[Whatever+1,nextWhatever])... as needed to split fields where I wanted. I knew importuning was deprecated; moreover, it fails syntax checks although it is still mentioned within a few help topics. Help suggests putting the same import() containing formulas that I’d used after
"REARRANGE", should give the same results. But even this most basic formula, to put each entire line into the first field of each record fails with the above error. Might PanX be doing something internally here with import() similar to whatever caused Michael’s problems between assign( and import(), which might help Jim fix both? Or am I misunderstanding something about
I’m glad Dave’s workaround sufficed for Michael, but I don’t see how to fit it into an importtext statement unless the following would work:
importtext array1, "REARRANGE",array(Array1,seq(),crlf())
and it doesn’t, instead adding the correct number of records, all full of empty text.