oshe127
asked on
How to manipulate data on a non-delimited text file?
I have a text file that is not delimited and I need to extract imformation from the file and place it in an sql database.
I am coding using VB.Net.
Is their some way in .Net to count the characters, so I can use that returned value to help me extract the
values I need.
I am using ASP.NET/VB.NET
Thanks.
I am coding using VB.Net.
Is their some way in .Net to count the characters, so I can use that returned value to help me extract the
values I need.
I am using ASP.NET/VB.NET
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The jet provider (ODBC adapter) supports fixed width files through the use of a schema.ini file.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcomregularexpressions.asp
They seem kindof cryptic at first but are a valuable tool.
Corey2