Eaho Laula (xterminal) wrote in vbdev,
Eaho Laula

  • Music:

Read, ReadLine, and annoying text files.

So I have this file I'm trying to read into SQL Server with a DTS package that uses a VBScript component (which is why I'm posting here).

Easy code:
	do until x.AtEndOfStream
		name_of_junk_var = x.ReadLine
		msgbox name_of_junk_var

Now, here's the hard part. I won't be able to post an example of the file, because the reason I'm using ReadLine is that when I open the file in notepad, the characters I see between lines are unprintables (represented in notepad with those generic little rectangles that tell me nothing).

So, questions.

1. Is there any way to play with what ReadLine sees as a row delimiter?
2. If not, is there any way for me to discover what these unprintables are without endless trial-and-error (since I assume I'll be using Read if ReadLine can't be modified)?

  • Post a new comment


    default userpic

    Your IP address will be recorded