EzGoingKev
Registered User.
- Local time
- Today, 11:20
- Joined
- Nov 8, 2019
- Messages
- 178
I have text like this:
L6 - 5.9L 359ci DIESEL DI Turbocharged vin C - 4 valve OHV
V8 - 6.6L 6599cc 403ci DIESEL MFI Turbocharged vin L type LGH - 4 valve OHV
I want to extract the VIN info - just the letters in bold. In these examples they are both single letters. Sometimes they can be a number. Sometimes there can be more than one character.
I tried using the code here and modified it to:
And I get an "Invalid procedure call " error. I have played around with it some but cannot get it to work.
Any help with this?
L6 - 5.9L 359ci DIESEL DI Turbocharged vin C - 4 valve OHV
V8 - 6.6L 6599cc 403ci DIESEL MFI Turbocharged vin L type LGH - 4 valve OHV
I want to extract the VIN info - just the letters in bold. In these examples they are both single letters. Sometimes they can be a number. Sometimes there can be more than one character.
I tried using the code here and modified it to:
Code:
Mid([FieldName],InStr(1,[FieldName],"vin")+4,InStr(1,[FieldName]," ")-InStr(1,[FieldName],"vin")-4))
And I get an "Invalid procedure call " error. I have played around with it some but cannot get it to work.
Any help with this?