Answer the question
In order to leave comments, you need to log in
How to get content back from md5 sum?
Good day to all! Already broke the whole head, maybe someone who knows will tell you. Look, I have one supplier, he generously gives me his price list for 50,000 items in which the product ID is not presented as "543623", but in the form of md5 "67a3d8f04b2c60006ca9a12504d6697f".
I import the product in such a way that its ID is printed in the name, i.e. "{name}+{id}"
At the moment, the only thing I found is a site that more or less allows you to batch process 3000 md5 lines at a time. But the processing speed is such that while I finish running 50,000 positions from MD5 into normal text, the price is already being updated, as a day passes.
Actually, here is the question itself, how can this whole thing be done, for example, in the same EXCEL, through the same VBA. Or maybe there is already some ready-made software that allows this process not to stretch for the whole day. How can you take for example these 50,000 lines, stick them in, press the "let's go" button and pick up understandable numbers instead of abracadabra.
Has anyone come across something similar, please let me know.
Answer the question
In order to leave comments, you need to log in
Calculate the hash of all digits from 1 to 100.000.000 yourself and save it to a fast storage or even to memory if it is enough and use it to search instead of third-party services.
no more than 9 digits are encrypted (article)
You are darkening something.
First, MD5 is an algorithm whose result is reversible with ambiguity, that is, there may be more than one row from which MD5 will give the one you are reversing.
Secondly, who in their right mind would (including for the reason mentioned above) use it for an ID?
It is not clear why these id do not suit you?
What's the point of wasting air?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question