Tom P.

I’ve run out of credits. I am going to need to do this manually

That is not accomplishing my goal. For example, Irving is just normalized to Irving, Tx

I figured it out

I figured it out

https://app.clay.com/workspaces/498799/tables/t_djZh3F7PrPo2/views/gv_F4cu7rSPhfgg

https://app.clay.com/workspaces/498799/tables/t_djZh3F7PrPo2/views/gv_F4cu7rSPhfgg

I tried that. I don't understand how to capture the data and extract it to a field

The output of outlook comes in a wide variety of formats. A regex pattern won’t work. Here is an example: John.doe@company.com Doe, Jane John S Smith t.tim@scrooge.com James.T.Kirk@starfleet.gov george_washington@us.gov Betsy Ross (b.ross@flag.com)