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