Author Topic: Batch txt files from a list  (Read 2520 times)

jkim

  • Jackass In Charge
  • Posts: 3290
  • Karma: +106/-12
Batch txt files from a list
« 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?

JaWiB

  • definitelys definately no MacGyver
  • Jackass V
  • Posts: 1443
  • Karma: +57/-4
Re: Batch txt files from a list
« Reply #1 on: September 09, 2013, 03:28:55 PM »
I'd probably export it as tsv and then write a python script  :dunno:

micah

  • A real person, on the Internet.
  • Ass Wipe
  • Posts: 6915
  • Karma: +58/-55
  • Truth cannot contradict truth.
    • micahj.com
Re: Batch txt files from a list
« Reply #2 on: September 09, 2013, 03:35:35 PM »
yeah, and I'd do it in PHP.  :dunno:
"I possess a device, in my pocket, that is capable of accessing the entirety of information known to man.  I use it to look at pictures of cats and get in arguments with strangers."

ober

  • Ashton Shagger
  • Ass Wipe
  • Posts: 14305
  • Karma: +73/-790
  • mini-ober is taking over
    • Windy Hill Web Solutions
Re: Batch txt files from a list
« Reply #3 on: September 09, 2013, 04:09:19 PM »
Probably PHP, maybe Java, or maybe just a bash script.

hans

  • Guitar Addict
  • Jackass In Charge
  • Posts: 3523
  • Karma: +46/-18
Re: Batch txt files from a list
« Reply #4 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.
This signature intentionally left blank.