Hi - I am trying to parse this (Booking Point) into just the number (Cost Center) and all text after the underscores (Description)
Booking Point | Cost Center | Description |
T__06158_BP_MBNA | 06158 | MBNA |
8861_BP_GROUP SALES | 8861 | Group Sales |
Thanks!
Solved! Go to Solution.
I used this expression:
\D*?(\d+)\D.*?_(.*)
It looks for non-numbers until it finds a set of numbers and then looks for the last stuff after the last underscore.
I put the expression into an RegEx tool (configure as parse).
Cheers,
Mark