Fix multiple entries at once

Hello all,

I am working on a project where I have instructed people to enter a heat number for metal they are testing as it comes in.

Problem is that for a heat example of XYZ 29-30, people have entered it as:

XYZ2930 Xyz 29 30 Xyz2930

I’d love to go through and fix all these for the sake of filtering easier, but this is like, 6 months of data and that would take a very long time. Is there anyway I can fix it faster, or just adjust my query filters? I need to find the average of a quality per heat number.

submitted by /u/EntropyLadyofChaos
[link] [comments]

Posted on