Request for some help on modification of the code (below). It is working fine at times and not on others.
The problem that I’ve been able to identify is that at times the format of the data in the Text document used varies, for which the logics haven’t been incorporated. My challenge here is to do with the identification of the issues. There is tremendous amount of data in the text files I receive, and since the current code reads the complete file at one go rather than line by line, nothing actually happens when the macro is run, and I’m unable to determine the reason which may be causing this…
Could there be a way to make customize it in a way where it helps me to spot the line in each of the notepad where there is a disconnect with the existing logic. I’ve attached my logic Text file on which the logics are based and this solution works accurately if the data is within those parameters
I would really appreciate if you could help me customize or make this more dynamic. I’ve been stuck on this for a while now.
Thanks you in advance!