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
389 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:
Herman D'Hondt 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Surprisingly, there is a lot to Gym battles, and I thought it would be helpful to share knowledge about all the ins and outs of this feature!
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.
The Bounty Board allows you to request an article or video on any technical topic, or fulfill a bounty request to earn points. Watch this video to learn how to use the Bounty Board to get the content you want, earn points, and browse submitted bount…
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now