Hi i need extract an identifer which is always 3 letters, four numbers. But the names length changes. As does the identifier.
See the line below.
(The identifier is CFG0603 but changes with each row)
Doe, John. CFG0603 Bruce Willis. Lunch. $138.00
This will be run For Each Row and then stored as a new column.
I also need the last price but that is a simple .split