473,804 Members | 3,732 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to parse variable length fields into multiple fields?

1 New Member
All,
I am new to VBA and programming in Access. I am trying to set up database to keep track of statistics. The problem that I am running into is that one of the fields is variable length (it has no upper limit to the entries though the each entries is separated by a comma and a is 8 characters long ) and I need to count the item in that field to as part of one of the statistics. Additionally this database is updated daily I need to figure out some way to past the data directly into access and then have access parse the field.

The data is being daily cut and pasted from a search engine program that is very non-user friendly and only produces dynamic content to searches. Ie I have query the larger database get the info I need then copy and past it from a html file and manually paste it into the spread sheet.

So far I have trying to get access to parse the entries in the the field into separate fields and automatically generate field headings but I have not had much luck so far. Any suggestions?

Attached is how the date looks now and how I would like it to be at the end.

Thanks
Attached Images
File Type: jpg Raw Data 1.jpg (34.6 KB, 216 views)
File Type: jpg Finished Data.jpg (23.5 KB, 161 views)
Jan 24 '11 #1
1 2087
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
Yes, its quite possible to do something like this. However, I need a better example of sample data then what you have provided. A screenshot with 10 or 20 rows of data would be good.

What method do you use to gather data? Directly linked tables? Importing tables? Exporting from 1 db, then importing into another?

The more accurately you describe your issue the more accurately we can assist.
Jan 24 '11 #2

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

Similar topics

16
1758
by: steflhermitte | last post by:
Dear cpp-ians, I am working with a structure: struct meta_segment { long double id; long double num; long double mean; bool done;
8
1743
by: yasaswi | last post by:
I am using field( substring( product_id, 1, 4 ), 'IR56', '1k09', '7a72', '6f22' ) > 0 in a where clause to select four different strings of same length. However I want to be able to search variable length strings, such as IR5671, 1k097, 7a72p123, 6f22qw. I will know the actual length of strings at run time. So please help me.
10
5543
by: Clay_Culver | last post by:
I have heard that it is possible to use classes + template magic to make standalone functions (or maybe just a functor which acts like a function) which can accept variable length arguments without using the elipse. For example, a funciton could take in 1 known type, then a variable list of other parameters: ReturnValueClass rvc = someFunction("Some known type", 1, 0.2, "string"); ReturnValueClass rvc2 = someFunction("Some known type...
5
11745
by: MLH | last post by:
I'm working with lots of long strings now, it seems. I have to import them & parse them constantly. The A97 memo field type supports only 32768 chars. What happens when this is processed... Dim MyString As String Am I getting VLS declaration or a FLS declaration? Can I control which I get somehow? I have done some homework, but I don't understand
3
3162
by: JIM.H. | last post by:
Hello, I am suing SELECT * from MyTable in a stored procedure and populate dropdown list. By using followings: ddlSP.DataSource = DS; ddlSP.DataTextField = "PName"; ddlSP.DataValueField = "PID"; ddlSP.DataBind(); This show PName in dropdown list, It is working fine. Now I need to combine PName, Field1 and Field2 as “PName: Field1 – Field2” and show it in the
3
30292
by: mkjets | last post by:
I have worked for hours on trying to find a solution and have not figured it out. I am working in Access 2003. I need to create a query that takes values from 1 table and displays them in multiple fields. I don't have the option of changing the structure of the existing tables because I am importing them from a separate data source on a regular basis. I also need to use a query instead of a form because I then need to be able to export...
0
1197
by: Humppatirallaa | last post by:
So, the problem is that I query data out of a ntext (variable length Unicode text) field, and it is corrupted near the end. Yes, I know that the misfeatures odbc.defaultlrl and odbc_longreadlen() exist, but what good are they if I don't know the data size beforehand? No, setting it to a very high value is not acceptable - it noticeably slows PHP down (as it is allocating the large buffer) and still poses a limit which can be broken. No,...
10
1732
by: uche | last post by:
Hello all! I have thought about this question for a long time and I would like to know your opinion about it: In C, a variable-length string can be carried in RAM as a sequence of ASCII characters followed by a NULL character. Would this work in a disk field? What are some considerations to be aware of?
2
2678
by: Nathan Sokalski | last post by:
I have a Repeater that uses a DataSource that has multiple fields. When the values of these fields is displayed in the Repeater, there are fields that are used in combination with other fields as well as by themselves. For example, there may be a firstname field that is used in combination with a lastname field as well as by itself. Using it by itself is simple, I have done that many times. However, is there a way to use multiple fields in...
482
28031
by: bonneylake | last post by:
Hey Everyone, Well i am not sure if this is more of a coldfusion problem or a javscript problem. So if i asked my question in the wrong section let me know an all move it to the correct place. what i am trying to display previously entered multiple fields. I am able to get my serial fields to display correctly, but i can not display my parts fields correctly. Currently this is what it does serial information 1 parts 1
0
9582
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10580
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10335
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10082
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9157
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 projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6854
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4301
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3821
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2993
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.