Problem: I am trying to export a single column of a .CSV file that is 7 gigs in size (large enough that I can't open the entire file in excel... or most text editors for that matter) to a smaller file that I can then use or put into a database without all the unneeded information.
Power Query: I've made a "connection" to the file and then selected only the desired column, but I'm not sure if there's a way to export that.
Alternative?: Alternatively, using Powershell there's most likely a way from what I've seen based on this question, but I'm not sure where to begin with that.
If there's any other resources that would be better for this, anything helping point me in the right direction would be awesome.
Any help is greatly appreciated!