SOLVED
Regex Parse by specific String
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
caldowd1998
5 - Atom
‎02-14-2022
04:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Community,
I'm looking to parse the following text into 2 columns with 'GBP' being the delimiter.
CHIN FONG 0.00 GBP 0.150 MIN 557212 P30040 LS
I've attempted using text to columns with not much luck, is there a way to perform this using a regex expression.
Thanks in advance !
Solved! Go to Solution.
Labels:
- Labels:
- Regex
2 REPLIES 2
22 - Nova
‎02-14-2022
04:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎02-14-2022
04:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @caldowd1998
Cheers and have a nice day!
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)