Extract one column from a CSV

Assuming your CSV looks like this

“211”,”customer name here”,”″,”2018-08-1309:51:28″
“339”,”fue bah”,”″,”2018-09-0619:28:30″

We can use Notepadd++ (or other tool) and some regex to extract the IP address.

Find what: ^(.*?),(.*?),(.*?),(.*?)$
Replace with: $3

Be sure to use regex if you’re on Windows/Notepad++!  This works with four “column” documents, to adjust it for more or less be sure to mirror the number of commas and use one – (.*?) – for each column.