Assigned for Awk in another Section

[BillRichardson]

so which post number is it ? all i can see is you have a lot of disparate batch files like awkbat6, awkbat8 etc ...can you combine the full solution into 1 batch file ??

Ghostdog74  or  BC  are welcome to offer their own Batch solution.

[ghostdog74]

Ghostdog74  or  BC  are welcome to offer their own Batch solution.

you are not answering my question. I am very interested in your batch solution, but you make it so hard to decipher which ones your final solutions are. I am merely asking you to reorganise your batches into 1 batch file. If you have done it, then which one is the actual one? post number 1??

And for your information, i have already solved it with gawk. that's why i am interested when you post a batch solution to solve the same thing. If you are not going to reorganize your code, its fine with me. but you are not helping the others who see this post, that is your philosophy right?

[BC_Programmer]

Billrich is welcome to post a perl solution.

[BillRichardson]

its from here

I could find no feedback from Eldorado, Topic Starter,  that the Awk (gawk ?) solution worked for Eldorado?


http://www.computerhope.com/forum/index.php/topic,97061.msg657265.html#msg657265

Topic: Record Manipulation with AWK  (Read 306 times)

Eldorado
Topic Starter

[BC_Programmer]

I could find no feedback from Eldorado, Topic Starter,  that the Awk (gawk ?) solution worked for Eldorado?

Sometimes when a solution works you never hear from the OP again. gawk stands for GNU Awk, (or, I imagine that's what it stands for).

[ghostdog74]

I could find no feedback from Eldorado, Topic Starter,  that the Awk (gawk ?) solution worked for Eldorado

why does it matter? if it doesn't work, he will post back.
and don't shift the subject focus. you provide a batch solution, but its all over the place. Can you put them into one batch file.? that's all i am asking. You can treat me as a beginner in batch and i am asking you a favor now to combine them to make it easier for me and others. how about that ?

[ghostdog74]

gawk stands for GNU Awk, (or, I imagine that's what it stands for).

yes.

[BillRichardson]

BillRichardson is welcome to post a perl solution.

BC may offer his solution in "C", "Assembly", Perl or Machine Language . . .
or any code at his command?

I thought the Hope Board was designed for Batch?

[BC_Programmer]

BC may offer his solution in "C", "Assembly", Pearl or Machine Language . . .
or any code at his command?

What the heck is Pearl? never heard of that language.

I thought the Hope Board was designed for Batch?

Don't recall it ever saying that anywhere. the DOS board would, ideally, be for DOS batch files, you know, for DOS, not windows with command extensions. the only reason the DOS board is being used for Windows-based batches with command extensions is because otherwise they may as well remove it. maybe 1 in a thousand people are actually referring to a pure DOS batch. Because of that, and the fact that all versions of windows down to windows 98 natively support languages such as VBScript and jscript as the official scripting language of  the OS, any feasible solution is valid.

If Ghostdog wants to post his solution in python, or awk, or what have you, then he's free to do so, especially when it solves the OP's problem. because, surprisingly, the OP most often doesn't really CARE what was used; as long as it solves the problem.

[BillRichardson]

All users of Windows have access  to Batch files. They can create and/or use Batch files.

Only one person in 1000 have access to Awk (gawk ) files.  Only one person in 3000 know how to use use Awk files.

[Salmon Trout]

Only one person in 3000 know how to use use Awk files.

And it isn't you, by the look of things!

[ghostdog74]

All users of Windows have access  to Batch files. They can create and/or use Batch files.

Only one person in 1000 have access to Awk (gawk ) files.  Only one person in 3000 know how to use use Awk files.

i wish you could just stop babbling your nonsense and focus on what I, as a beginner in batch, wish you would do for me. Show me the final batch solution,  in one batch file.

[BillRichardson]

I look forward to your final result.

See  awkbatfinal.bat in the opening post of this thread.

There is only one main batch.  The main batch calls awkbat6.bat  and awkbat8.bat for lines 306 and 308.

[eldorado]

Code: [Select]

awk -F"|" '{
    a[$1]=a[$1] FS $2 FS $3
}
END{
    for(i in a){
        print i,a[i]
    }
}' file


output

Code: [Select]

$ ./shell.sh
301 |AF_ACC_BDL|774;|AF_WMG_BDL|6660;|AF_REP_BDL|4735;
303 |AF_ACC_BDL|1360;
304 |AF_ACC_BDL|5092;
305 |AF_ACC_BDL|32384;
306 |AF_ACC_BDL|80859;|AF_REP_BDL|80875;
308 |AF_ACC_BDL|1418;|AF_WLH_BDL|78273;|AF_WSL_BDL|9990;|AF_WFL_BDL|9998;



Hi ghostdog74,

The solution you provided works perfectly. Thanks alot! 

[ghostdog74]

See  awkbatfinal.bat in the first post of this thread.

ok, i seen your code, but i wonder where are awkbat6.bat and awkbat8.bat ?? I have also run your code, but i have another question, if i have more data, like 309, 310, 311 etc...do i have to create awkbat09.bat , awkbat10.bat, awkbat11.bat etc as well??