EntropySink
Technical & Scientific => Programming => Topic started 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?
-
I'd probably export it as tsv and then write a python script :dunno:
-
yeah, and I'd do it in PHP. :dunno:
-
Probably PHP, maybe Java, or maybe just a bash script.
-
I'll be it can be done with AWK or something if you export the excel files to CSVs.