How to split a string before a text using RegEx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Custom Tools
- Input
- Output
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@grazitti_sapna , @ChrisTX any thoughts?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am using AT1(.*) but it will only work for AT1###
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
REGEX Parse (.*)(AT\d.*) should work
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.