Hello everyone
There is a task to process an Excel file with data, specifically it contains auto parts numbers. I am attaching an example of the data before and after processing.
It is necessary to process the initial line so that the output contains only the parts numbers (without extra characters and words) separated by commas.
Manual processing will take a very long time because the file has 380,000 lines.
The task is more suitable for automated processing, but there is also a problem that in the initial line, the parts numbers may be written differently and in various combinations.
One possible approach is to create masks based on manufacturers, there are only 20 manufacturers in total.
I am available and will answer all your questions.
It is preferable to understand the logic of auto parts numbers, but if you do not understand, the file will contain links to the original product and their photos, where you can see which numbers are correct.
Perhaps you already have experience with similar tasks, I will be glad to hear your proposals.
In your response, please specify realistic deadlines and costs, considering that there will be about 380,000 such lines (but not all are formatted the same way, many just have extra spaces or other characters).
Work only through escrow with prepayment and other payments!
Comments like - contact us, we will do it, etc., will not be considered. Before adding your bid, please review the technical specifications and the example file.