A
A
alexbelru2019-08-23 10:12:33
Hashing
alexbelru, 2019-08-23 10:12:33

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

4 answer(s)
V
Vitaliy Orlov, 2019-08-23
@orlov0562

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.

J
jcmvbkbc, 2019-08-23
@jcmvbkbc

no more than 9 digits are encrypted (article)

Hashed. You can stupidly decide on the forehead, 9 digits - this is a billion options. You can count them all, sort them and put them in a file, in text form it will take ~ 50 gigs, the search will be almost instantaneous.

M
Moskus, 2019-08-23
@Moskus

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?

L
Lynn "Coffee Man", 2019-08-23
@Lynn

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 question

Ask a Question

731 491 924 answers to any question