Basic Instr question

[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

 

[Jon Skeet [C# MVP]]

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.

 

[Mike Anderson]

Thank you

-----Original Message-----
string

Use String.Substring to retrieve the string itself.

--
Jon Skeet - <[email protected]>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
.

 

[Scott M.]

i = left(strinfile,InStr(strinfile, "IEA*")-4)