How to split a string before a text using RegEx

[Arunima_S]

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!

[Arunima_S]

@grazitti_sapna , @ChrisTX any thoughts?

[Arunima_S]

I am using AT1(.*) but it will only work for AT1###

[ImadZidan]

@Arunima_S ,

an idea.

Hope it helps

[vizAlter]

@Arunima_S — Attached workflow has both the methods — (1) When "AT" is followed by 6 digits, (2) When "AT" is followed by any digit

If this posts assists in resolving the question, please mark it "Like", or "Solved" if it resolves the question. This will help other users find the same answer/resolution. Thank you.

[wwatson · Accepted solution]

REGEX Parse (.*)(AT\d.*)  should work

[grazitti_sapna · Accepted solution]

Hi @Arunima_S , You can try this 

Regex-(.*)(AT\d.*)

The regex will work for the following pattern having AT follwed by digits and then some string.

Thanks.