Hi,
I am trying to split a column right before "AT" followed by a digit using Reg Ex. Example:
Input:
| Field 1 |
| aeccr53424drgef32453AT102030fanewors |
| |
| wedx253wdasdfkjreAT0203103wec244255v |
| |
| kerthwATjeeydkAT230193ertogisnfslae |
Output:
| Field 1 | Field 2 |
| aeccr53424drgef32453 | AT102030fanewors |
| | |
| wedx253wdasdfkjre | AT0203103wec244255v |
| | |
| kerthwATjeeydk | AT230193ertogisnfslae |
Can you please help me with an expression that I could use to achieve the same?
Help is very much appreciated!
Thank you!