Hi, I’m trying to create an automation that loops through my excel sheet and checks the dot (.) count of the cells in each row. There are 3 types of data for column A;
Column A, Column B
If 100.01.01 exist discard the other ones. That’s easy with a regex that checks dot counts.
But if 100.01.01 does not exist get the 100.01’s value. I couldn’t find a way to get this one.