Code to Rename multiple *.txt files

  • Status: Closed
  • Prize: $10
  • Entries Received: 21
  • Winner: MagnusArtero

Contest Brief

Hello Everyone!

The goal of this contest is to develop two tools or codes:

1. The first one will have to rename the *.txt files which contain a conversation between two usernames with the following format: username1_username2.txt

2. The second one will have to open all *txt files in a single workbook where each file must be a different spreadsheet of the workbook. It must also include the headers and the format stated in the excel file.

*Feel free to code in the language that you are most familair with.
**In the case that nobody performs both tasks, the prize will be awarded for the one who provides the best solution for at least one of the two tasks stated above.

*UPDATE: Given the large amount of entries received so far, I ma adding an additional feature, which its not mandatory but will add extrapoints to the one who achieve it. The additional feature consist in merging all the worksheets generated from each file into a single one with an additional column with the name of the original worksheet. Please see example attached. A nice user interphase will also be considered. Thank you!

Thank you and looking forward to meet you!

Cristobal

Recommended Skills

Employer Feedback

“If you want to play it safe and have the right solution for your need in the right time, then hire Magnus”

Profile image cbucher, United States.

Top entries from this contest

View More Entries

Public Clarification Board

  • shopshoppy
    shopshoppy
    • 5 years ago

    can we discuss

    • 5 years ago

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!