Extracting an identifier from a datatable or Excel

[Jamie3 (Jamie)]

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.

[ppr (Peter)]

@Jamie3
Welcome to the forum

Regex can help

[A-Z]{3}\d+

Anchored to the dollar sign

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum
(?<=\$)[\d.,]+

[Jamie3 (Jamie)]

Awesome thanks