I’ve been working on a Powershell script that creates many text files of various directories scattered on a network. Each text file contains lists of the file content of a network directory, name and extension.
I figured I may as well use Airtable to audit each text file - which it does well. But the catch is, I’m not sure how I can actually parse a text file that I’ve uploaded into the Airtable attachments field into a Long Text field. Can this be done via an Automation?
It was great when I discovered that I could bulk upload Text.txt files into separate records via the Gallery View Yellow button, simply select a bunch of files and drag it to the button - Excellent - that solved my first hurdle!!! But… now… I’m slightly concerned that as easy as those text files were to upload, I’ve no actual method to copy their content into a Long Text field and then do my usual Airtable formula thing to pull the text data apart.
Appreciate any guidance on this! Perhaps I’ve gone about this process upside down? Keen to hear your thoughts.
PS: I briefly looked into this completely different method here;
Where by using the Scripting App to upload a text file and copy its content into long text fields (doesn’t matter that the actual file isn’t attached as an attachment, I just need the text data into a long text field), but I wasn’t sure of how I could bump the script from importing one file at a time, to many files in one process.