control character in CSV

[zdrakec]

Hello all:

I hope someone can explicate this for me:

I have a csv file whose last line consists of two characters are the
hex char 1A (decimal 26, or ^Z) followed by an equal sign ("="), thus:

data,data,data
data,data,data
data,data,data
^Z=

A StreamReader object, encountering this, is returning the filename. Is
this expected, documented behaviour; if so, can someone point me too
it?

Thanks much,
zdrakec

 

[Chris]

Hello all:

I hope someone can explicate this for me:

I have a csv file whose last line consists of two characters are the
hex char 1A (decimal 26, or ^Z) followed by an equal sign ("="), thus:

data,data,data
data,data,data
data,data,data
^Z=

A StreamReader object, encountering this, is returning the filename. Is
this expected, documented behaviour; if so, can someone point me too
it?

Thanks much,
zdrakec

maybe simple code that shows the problem would help us help you.

Chris

 

[zdrakec]

Actually, it's not the StreamReader, but the parser we pass the output
to, that performs this behaviour. I don't have the code, this was
reported to me by a partner of mine.
I guess this isn't a VB question at all. It turns out that the
character ^Z (hex 1A, octal 32, decimal 26) is the substitute control
character, and to the parser we use (and some other systems, I guess),
the string "^Z=" means "substitute the filename here". I'm just looking
for some knowledge about this, either through expertise available on
this group, or documentation, or what have you...

Thanks much,
zdrakec