Pull 8 Digit value out of Comment field

[crystles]

I have a data set that has a Comments section and in this section they usually put Missing items in it.I want to be able to pull those Item numbers out of the Comments field.

Comment Field Examples.

• Missing: 12345678
• ItemName 12345678 Item description
• Item description 12345678

So it is very random where the numbers may end up in the code. I do have a list of all items I could match it too to pull out the number, but I can't figure out how that would work.

Any help or ideas would be greatly appreciated. Thanks!

[crystles]

Yes, I can certainly do that. I was only using number there, because the 'ItemsFromComment' field was showing up as numerical. So I'd want to change that one too.

I'll be joining these to another table as a new field, so I will probably just change it to Text there, instead of having to do it twice here.