I have a file that is very long from right to left with 40 different fields. In the old pan 6, I used to be able to split a field and see other fields that were not on the screen.
Is there a way in Pan X to accomplish the same goal? I can’t find spitting a file in half on the help menu.
Thanks
Take a look at the Hide/Show Fields menu choice in the Fields menu.
And note that you can set Favorite hide/show options.
I tried it and didn’t know what I am trying to do???
While you said you could split a field, I presume you meant that you could split the window. That let you ‘hide’ fields between the rightmost field on the left side, and the leftmost field on the right side of the window.
ie. Now you can use the dialog to hide fields ‘D’ through ‘W’ and only view A,B,C,X,Y,Z (in a file with fields A->Z)
Then too, you can also programmatically HideTheseFields & HideFieldsBetween amongst other similar options.
I have seen it and understand about hiding fields. On my five year old mac it struggles to hide like 30 field on a file with 20,000 entries. I also see I can make it a favorite and do it all the time. Just a struggle for my computer to do this, especially going back and showing the 30 field to add back to the file
What do you mean by “struggles”?
Why wouldn’t you just use Show All Fields?
It takes 20 to 30 seconds to eliminate the fields, when I try to add it back on it sometimes doesn’t do it. Also had problems that the header went to a different font and wouldn’t line up. Also had it crash a couple of times.
Sorry, big file i guess. Other than that, it handles things fine.
On a file with 20,000 records, it was significantly sluggish to allow me to select 30 fields. ~1 min 50 secs to check 30 checkboxes. I then set that as a favorite.
The actual hide was instant. The retrieval to Show All Fields was instant. The hiding of the fields a 2nd time was essentially instant.
This may not be as easy as sliding a lever back and forth but it is what it is. Kinda like the loss of the Design Sheet. You get over it. Never quite the same as losing an old friend, but lots and lots of standardization and many new features.
I can’t imagine what you are doing. My computer is also 5 years old (from 2020). I just tried this with the US Airports database which is used for many of the Panorama video demos. This database has 66 fields and almost 20,000 records. I can switch between different favorite configurations of fields in a fraction of a second. I’ve never heard of this feature crashing or of problems with the header.
FYI, 20k records and 40 fields is not that big of a file. There have been Panorama databases with over a million records, and with hundreds of fields (though I don’t think both of those in the same database). I heard from a researcher in 2020 that was working with databases for Covid research that were over 60 Gb (this was on an Intel Mac Pro with 1.5Tb of memory).
Instead of clicking 30 field names in the show/hide dialog you can use the statement hidefieldsbetween. It works with field names as well as with field numbers. So you can use code like this
hidefieldsbetween 5, 35