i need assistance extract the following 12345 from 3001-12345Y 6534 from 2007-6534Z thank you
S stevensZoe May 16, 2005 #1 i need assistance extract the following 12345 from 3001-12345Y 6534 from 2007-6534Z thank you
S stevenszoe May 16, 2005 #3 thank rick. but if I have a value 2007-653Z I am getting 653z. I am needing just 653. the number of digits before the letter is variable. Rick B said: Mid([SomeFieldName],6,4) -- Rick B stevensZoe said: i need assistance extract the following 12345 from 3001-12345Y 6534 from 2007-6534Z thank you Click to expand... Click to expand...
thank rick. but if I have a value 2007-653Z I am getting 653z. I am needing just 653. the number of digits before the letter is variable. Rick B said: Mid([SomeFieldName],6,4) -- Rick B stevensZoe said: i need assistance extract the following 12345 from 3001-12345Y 6534 from 2007-6534Z thank you Click to expand... Click to expand...
