Hello there, recently one of the analysis I'm doing is searching for flip-flop changes on logs.
For instance detecting these type of changes:
Detecting flip flop changes on numeric numbers is easy. I usually create a field that appends both numbers as a string and constantly follow the logic of writing the small one first and then the larger one. This will create the same string wether the change is 100 to 1000 or 1000 to 100 and they are easily detected by searching for duplicates no that newly created field.
However I can't apply the same logic to character fields. Is there any criteria that I can use in order to achieve something like this that works no matter how the strings are written or their size?
Last seen: 3 months 1 week ago
Joined: 06/06/2017 - 10:54