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!
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.
.png "crystles"){kind=avatar}
