Thanks Manikatna.
Hi @DanLit,
Nice example... one small correction though.
I think the RegEx pattern the last digit has to be 7 instead of 2 as the IndData is 12A27
Pls correct me if I am wrong.
Hi,
Yes you are right mundhir123
Regexopattern: ^([0-9]){2}(A)([0-9]){2}
^ = starts with
([0-9]) = () a group, this is first group, [] range, so full first group is a group with range 0-9
{2} = number of times this should occur, {2} says the group abowe should occur 2 times
(A) = new group, only matches a A
([0-9]){2} = another group with two digits.
Also try https://regex101.com/ for testing your patterns.