Not easily. Its more about understanding the data. For instance:
345678910
You could assume the last two digits are the final number, but:
345678190
Would the last two still be the last number? Or should it be zero and the previous one be 19?
Why is the data like that? A demilited file will make your life a lot easier.
Also note that your want dataset data does not match you have data, row one does not contain a 9 for instance, and there are four rows in the have and only 3 in the want. Perhaps provide some acurate test data and describe what you want in more detail, i.e. the how and why.
... View more