@Yesha
Yes! I will explain, and please let me know if the thought process will mess you up.
I only saw three different types of options in the first data column: A Date, a City, and some value of Upper Case letters.
Therefore, in the formula tool, I took the 2 left characters and said that I know the city will first have an upper case character, and the second character should be lower case. If this is the scenario I know I'm dealing with a city and not a date or some value with just Capital characters.
Therefore, basically the RegEx reads
( - open the field you want to parse
^ - I'm starting at the beginning of the line
\u - confirm that the first character is upper case
\l - confirm that the second character is lower case
) - close the parsed line
The value -1 means that we are dealing with an upper case character followed by a lower case character, while the value 0 means that it is not the case.
Is that more clear for you?
Please like and accept if this answers your question and feel free to continue to ask away 🙂
J
