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

can slurp do this?

P: n/a
hello

Say I am interested in users giving me values for a, b, c and d.

I have a file with all the results - a very big file!

user 1
a: one
b: two
d: four

user 2
a: one
b: two
c: three
d: four

etc etc

and want to create a file

user a b c d
1 one two x four
2 one two three four

etc etc

How do I put in an x for c for user 1, indicating that this user
didn't submit a value for c?

I slurping the way to do it?

Cheers

Geoff
Jul 16 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Geoff Cox <gc**@freeuk.notcomwrote:
>hello

Say I am interested in users giving me values for a, b, c and d.

I have a file with all the results - a very big file!

user 1
a: one
b: two
d: four

user 2
a: one
b: two
c: three
d: four

etc etc

and want to create a file

user a b c d
1 one two x four
2 one two three four

etc etc

How do I put in an x for c for user 1, indicating that this user
didn't submit a value for c?

I slurping the way to do it?
No need for slurping in the whole file. If you know the set of all a, b,
c, d, ... in advance then just go ahead and create the top row. Then
read in the information for each user and print the row for him.
If you don't know the set of all a, b, c, ... in advance then read the
file twice: first pass just to determine the set of a, b, c, ... and the
second pass as above.

jue
Jul 16 '08 #2

P: n/a
On Wed, 16 Jul 2008 13:51:15 GMT, Jürgen Exner <ju******@hotmail.com>
wrote:
>Geoff Cox <gc**@freeuk.notcomwrote:
>>hello

Say I am interested in users giving me values for a, b, c and d.

I have a file with all the results - a very big file!

user 1
a: one
b: two
d: four

user 2
a: one
b: two
c: three
d: four

etc etc

and want to create a file

user a b c d
1 one two x four
2 one two three four

etc etc

How do I put in an x for c for user 1, indicating that this user
didn't submit a value for c?

I slurping the way to do it?

No need for slurping in the whole file. If you know the set of all a, b,
c, d, ... in advance then just go ahead and create the top row. Then
read in the information for each user and print the row for him.
If you don't know the set of all a, b, c, ... in advance then read the
file twice: first pass just to determine the set of a, b, c, ... and the
second pass as above.

jue
thanks Jue - will give this a try.

Cheers

Geoff
Jul 16 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.