EntropySink

Technical & Scientific => Programming => Topic started by: jkim on September 09, 2013, 02:45:32 PM

Title: Batch txt files from a list
Post by: jkim on September 09, 2013, 02:45:32 PM

So let's say I have 400 one-line text files that need to be generated from 2 columns of data in an excel source file. If need be, it can be split into multiple 1 column excel files.

What would be the easiest way to batch "A1|B1|Rest of message" into A1.txt, "A2|B2|Rest of message" into A2.txt, etc?

Title: Re: Batch txt files from a list
Post by: JaWiB on September 09, 2013, 03:28:55 PM

I'd probably export it as tsv and then write a python script  :dunno:

Title: Re: Batch txt files from a list
Post by: micah on September 09, 2013, 03:35:35 PM

yeah, and I'd do it in PHP.  :dunno:

Title: Re: Batch txt files from a list
Post by: ober on September 09, 2013, 04:09:19 PM

Probably PHP, maybe Java, or maybe just a bash script.

Title: Re: Batch txt files from a list
Post by: hans on September 09, 2013, 04:23:27 PM

I'll be it can be done with AWK or something if you export the excel files to CSVs.