I'm trying to match a pattern and then extract the next two characters after pattern match. What is the Regex that I can use.
ASOD-CT sdjfkfjkh 359
euhndkn ASOD-CA 3845
3849 ASOD-AZ sdkkj
Expected result
CT
CA
AZ
I tried (.*ASOD-\u{2}) but it is not recognizing
Solved! Go to Solution.
Hi @monish_chandra !
I'm not sure if I understood well, do you need to take the 2 letters after "ASOD"?
If is that, you can use regex tool with tokenize configuration, there use the expression "ASOD-[A-Z]*" and after that use a formula tool with the formula "left([Regex result],2)"
Hope that helps!
Happy to help 🙂 @monish_chandra
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂