Hello,
I'm trying to use regex to parse some characters from an order number string. If the order number ends in '00' or '01' I want to parse the string into Order Prefix and Order Suffix fields
Order Prefix Order Suffix
73528489802 01
72584895012 00
If the order number ends in something other than '00' or '01', I want the entire order number in the Order Prefix field and Order Suffix to be null
Order Prefix Order Suffix
7353964335239 null
Using (.*)(00|01)$ I get the desired results if the order number ends in '00' or '01'...other wise both regex outputs are null
If I make the second group optional using (.*)(00|01)?$ the entire order number shows up in the first output group.
Order Prefix Order Suffix
7352848980201 blank
7258489501200 blank
7353964335239 blank
I've attached an example workflow.
Data:
| Order Number |
| 7352848980201 |
| 7258489501200 |
| 7353964335239 |
| 8011724161244 |
| W73368203492 |
| 8005687663201 |
| 8015624961200 |
| 8015624961299 |
| 8020874081211 |
| A020896796201 |
| 8020896796201 |
