By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

File parsing

P: n/a
I am requested to parse a file where some field values
are transferred to new rows as follows :

Existing file and field values :

Code Field A Field B Field C
101 50 20 30
102 40 10 60
201 170 180 90
202 100 110 120

New generated file and field values :
Code Field A Field B Field C
101 50 20
102 40 10
103 30
104 60
201 170 180
202 100 110
203 90
204 120
At this point I do not know if I can achieve this
thru a simple query or be obliged to do it thru VBA.
In either case, what would be the solution.

Thank you for your help.

J.P.

Aug 23 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Okay, I admit it. I'm clueless. What's the pattern here? Could you
explain it? How do you get from the first sample to the second? What
do you mean "parse"? if the data is already in separate fields, why do
you need to parse anything?

Aug 23 '06 #2

P: n/a
The pattern is that Field C codes have changed.

I think you're out of luck. If there is a true pattern you can
probably write some code that looks at each line says if Field C is not
null and Code = 101 then NewCode = 103 or something, dump the results
into a temp table and then join the tables.

This is why a proper table of this nature has only 2 fields; once you
change an assignment your whole table is phuxored. Always keep
scalability in mind.

pi********@hotmail.com wrote:
Okay, I admit it. I'm clueless. What's the pattern here? Could you
explain it? How do you get from the first sample to the second? What
do you mean "parse"? if the data is already in separate fields, why do
you need to parse anything?
Aug 23 '06 #3

P: n/a
Scratch that, I meant 3. "Code", "Field" and "Value".

ManningFan wrote:
This is why a proper table of this nature has only 2 fields; once you
change an assignment your whole table is phuxored.
Aug 23 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.