Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.