Hi Wayne - you have been very helpful; thank you.
I work at a film / tv post production facility. We use Outlook365 and the Sharepoint feature to share Word Docs and Excel Spreadsheets virtually. I use the Excel functionality in Sharepoint so that we can track media we copy to our StorNext SAN volumes as well as the multiple LTFS and Tar Per Shot LTO5s we write for both our clients and as internal data backups. Managing the media is beyond critical as TV and Feature studios require the utmost care of their OCF (original camera footage) and dailies / editorial media.
Of the many toolsets we use to edit and color shows and feature films is the AutoDesk platform (think Flame, Inferno, Smoke). The application toolset writes over 20TBs of data to our SAN volumes and the way it writes the data is unique to the application. If you tried to look at via a Mac Finder or Windows Explorer, the hex values in the filenames would not make sense. We cannot associate those hex names with actual human readable project names.
One of my engineers used the AutoDesk app to spit out a 1 million line plus text file with human readable names of every project, file type and file path.
What I am trying to do is suck all of that data into a spreadsheet that I can upload to Sharepoint (or paste directly into Sharepoint). When I try to copy/paste on my Mac Mini directly into a Sharepoint page, both Safari and Firefox go into a spinning beach ball of death. Time stops; photons of light are bent towards the event horizon; you get the picture.
Since Numbers won't accept more than 65,000 lines, I need a way to get that data into a spreadsheet.
I have downloaded LibreOffice and will give that a try.
Knowing what you do now, might you have any other suggestions?
Thank you again.
Scott