Extracting an identifier from a datatable or Excel

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

Help appreciated.

Welcome to the forum

Regex can help


Anchored to the dollar sign

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

Awesome thanks