473,396 Members | 1,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

How to define a recordset when using text data

Hi,

I have looked all over and cannot get my head around the following. I hope someone here can help.

I'm making a program in MS Visual Basic 2010 Express that will read a text data file and write the entire file to a text box. The data in said text box is then manipulated. These changes affect the entire data so I got that part done. The issue I have now is that I want to split and sort the data but need to define a recordset before doing so.

The records in the data are variable length (lines). There are characters that distinguish the start of a record. I want to be able to add the text of a entire record to another text box and use buttons to step through the data.

Here is a sample of what the data looks like.

Expand|Select|Wrap|Line Numbers
  1. SC000000
  2. SA02-Oct-2015
  3. SA02-Oct-2015
  4. SA02-Oct-2015
  5. SK
  6. SKSome text added here
  7. SKSome text added here
  8. SKSome text added here
  9. SKSome text added here
  10. SK
  11. SKSome text added here
  12. SC000001
  13. SA02-Oct-2015
  14. SA02-Oct-2015
  15. SK
  16. SKSome text added here
  17. SKSome text added here
  18. SK
  19. SC000002
  20. SA02-Oct-2015
  21. SA02-Oct-2015
  22. SK
  23. SKSome text added here
  24. SKSome text added here
  25. SKSome text added here
  26. SK
  27. SKSome text added here
  28. SKSome text added here
  29. SKSome text added here
  30. SKSome text added here
  31. SKSome text added here
  32. SK
  33.  
One can see that the start of a recordset is SC00 etc. Also note that the records, as mentioned before, are variable in the length of how many lines they contain. The data can also be in excess of 500 000 lines.

Any suggestions/help will be greatly appreciated. I have not coded in VB since school days and allot has changed since VB6.

Regards,

S
Apr 29 '16 #1
0 1009

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: va | last post by:
I am trying to create recordset from a text file. The text file contains header and records. The text file is tab delimited. I am using the following statement to create the recordset Call...
5
by: adrian | last post by:
hi all this is my first post to this group, so pls bear with me while i try to make some sense. i am trying to create a sproc which uses dynamic sql to target a particuar table eg. '.' and...
1
by: Dermot O'Loughlin | last post by:
Can anyone help me with this? I get the following error when using the odbc adapter wizard in VS.Net 2003: --------------------------- Wizard Form --------------------------- An unexpected...
6
by: sdowney717 | last post by:
Code page translations are not supported for the text data type. From: 1252 To: 950. I would like to know what this message means. I also installed the language packs in advanced settings,...
2
by: aaj | last post by:
Hi all I have a small but rather annoying problem with continuos forms, and am wondering if anyone can suggest a method of getting over it. The front end is Access 2002 with the BE being SQL...
0
by: Vince Campanile | last post by:
Ive got what must bea very basic question, but its got ne thouroughly stumped. Im writing a very simple application in Visual Basic.Ne 2003, thats using a data adapter hooked up to an Access...
2
by: ronhvb03 | last post by:
I'm fairly new to VB.Net. Anyway our office has a simple application written in VB6 thats produces a recordset from an Access database then writes the resulting recordset to a text file. They want it...
7
by: kr | last post by:
Hi All, Suppose I consider a sample program as given below:- #include<stdio.h> #include<stdlib.h> int i; int main() { char *test(int i); char *tmp = NULL;
6
by: insirawali | last post by:
Hi all, I have this problem, i need to know is there a way i cn use the data adapter's update method in this scenario. i have 3 tables as below create table table1{ id1 int identity(1,1)...
1
by: raddrummer | last post by:
Hi gang, I'm stumped on something that I've been at for a few days and so am seeking help. I'm sending emails to managers to let them know that a performace review is due and attach a custom...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.