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
455 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
  • 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Saved searches can save you time by quickly referencing commonly searched terms on any topic. Whether you are looking for questions you can answer or hoping to learn about a specific issue, a saved search can help you get the most out of your time o…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

809 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