[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

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.
0
oshe127
Asked:
oshe127
1 Solution
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now