I am new to vb scripting and was looking for a way to look up a file
and identify all the charachters between two delimiters and insert
them into a field of a table.The file is having data limited by
hex(07) delimiters and i am able to identify the first delimiter as
followws,How can i identify the data between 2 delimiters and insert
it into a table.


Thanks

Ajay


************************************************** ******************
' Visual Basic ActiveX Script
'************************************************* *******************
Function Main()

dim pipect,i,fld,c
dim column(50)

Set f1o = CreateObject("Scripting.FileSystemObject")
Set f1 = f1o.OpenTextFile("T:\Load to SQL\testfile.txt" , 1)

Do Until f1.AtEndOfStream
c = f1.Read(1)
msgbox "value of c" & c

if c = Chr(7) then
msgbox "found the delimiter"
end if
Loop
Main = DTSTaskExecResult_Success
End Function
=================================

Chr(7) is the character represented by x07

Are you saying that you have a delimited text file?

Have a look at this.

Coping with text files and abnormal column or row delimiters
(http://www.sqldts.com/default.aspx?257)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Ajay Garg" <ajayz90 (AT) hotmail (DOT) com> wrote