Link to home
Start Free TrialLog in
Avatar of oshe127
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.
ASKER CERTIFIED SOLUTION
Avatar of checoo
checoo

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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