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.
oshe127Asked:
Who is Participating?
 
checooCommented:
you can try using String.Substring function
0
 
Corey ScheichDeveloperCommented:
These are normaly a good place to look into Regular Expressions  Very quick and effective way of deciphering and splitting alot of data.

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
0
 
RobertRFreemanCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.