Home Posts tagged "Headers"

Tag: Headers

Peaking inside large files and getting Row counts plus headers with AutoHotkey

I used to be a data scientist and would have large (over 3 gig) files that I’d want to “peek” understand the data structure (See the headers, get a count of rows, etc.)

I wrote this simple AutoHotkey script which opens files pretty quickly

Peaking inside large files and getting Row counts plus headers

Script for Peaking inside large files and getting Row counts plus headers

Find Column Header in Excel & return location with AutoHotkey

Column Header in ExcelTwo women in an office smiling at a computer screen, one pointing at it while the other sits beside a green bottle on a desk.Often I’ll import a file which had headers and I’ll want to determine what column specific headers are in. This AutoHotkey function shows how you can pass an Array of search terms and return the Column Header in Excel in a key-value paired object.

Here’s the video walking through how to Find Column Header in Excel

Find Column Header in Excel & return location