Solved

Need to convert the text in a csv to a MD5 hash list of strings in an output csv

Posted on 2013-12-04
4
515 Views
Last Modified: 2013-12-06
Not sure what topic this would go under as I'm sure there are quite a few ways to accomplish the task. Looking for a utility or script that can parse the strings out of a CSV convert them to MD5 Hash strings and output them back to a CSV. I was thinking an excel function would be easiest but have not been able to find anything handy. Any input would be appreciated.
0
Comment
Question by:alduduk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 4

Expert Comment

by:andrew_man
ID: 39696420
MD5 hash values are not reversible!
0
 

Author Comment

by:alduduk
ID: 39696442
Not sure what you mean by reversible, I need a CSV file with the MD5 values as the end product, I'm not looking to reverse the process. Just need to convert the existing values in the CSV file to the equivalent MD5 values in an output CSV. I can see how to do this easily for a single string, but the CSV I need to convert has 140,000 strings that need to be converted.
0
 
LVL 38

Accepted Solution

by:
hdhondt earned 500 total points
ID: 39696957
This site has the algorithm for the conversion, along with some code explanations. There is also a link to a Javascript version of the algorithm.

I am a lousy programmer, but if you are proficient in VBS you can use that to create a macro that should do the job for you.
0
 

Author Closing Comment

by:alduduk
ID: 39701730
Thank you very much I appreciate the input.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question