473,394 Members | 1,889 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,394 software developers and data experts.

How to parse variable length fields into multiple fields?

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, 214 views)
File Type: jpg Finished Data.jpg (23.5 KB, 159 views)
Jan 24 '11 #1
1 2072
TheSmileyCoder
2,322 Expert Mod 2GB
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
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
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...
10
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...
5
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...
3
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";...
3
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...
0
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...
10
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...
2
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...
482
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. ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
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...
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...

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.