Basic Instr question

  • Thread starter Thread starter Mike Anderson
  • Start date Start date
M

Mike Anderson

I'm trying to get the "string" results of anything
before "IEA*" in my incoming text file. However the
instr returns the integer (char number 4968) verses the
string itself.

Any suggestions would be most appreciated.

i = InStr(strinfile, "IEA*") 'returns 4968 vs long string

Cheers,
Mike
 
Mike Anderson said:
I'm trying to get the "string" results of anything
before "IEA*" in my incoming text file. However the
instr returns the integer (char number 4968) verses the
string itself.

Any suggestions would be most appreciated.

i = InStr(strinfile, "IEA*") 'returns 4968 vs long string

Use String.Substring to retrieve the string itself.
 
Back
Top