Hi. I know I've done this before, but for the life of me, can't remember how. I need to be able to extract a string that will vary in length, that will always be between to characters. For example, these are document names:
02-20-00-AI-0035
02-2006-00-HG-0137
02-21-00-JW-1001
04-2115-01-AI-1013
I only need the portions (highlighted in red text) that will always be between the first and second "-" character. This portion of the document name is the "skid number". I need to be able to extract just the skid number from the document name.
If this can be done in an expression written into the design view of a query, that would be most ideal as I am not great with VBA at all.
Thank you!!
02-20-00-AI-0035
02-2006-00-HG-0137
02-21-00-JW-1001
04-2115-01-AI-1013
I only need the portions (highlighted in red text) that will always be between the first and second "-" character. This portion of the document name is the "skid number". I need to be able to extract just the skid number from the document name.
If this can be done in an expression written into the design view of a query, that would be most ideal as I am not great with VBA at all.
Thank you!!