	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.5

File manipulation using Windows MS- DOS-Batch

Asked by pal2k in Perl Programming Language, MS DOS

Tags: Windows MS-Dos batch script

Hello folks,

I need a help in csv file manipulation in dos-batch script

Question/help:
I have a csv file
File name : input_file.csv

field1, field2
a1,b1
a2,b2
a3,b3
a4,a4
a5,a5

I have mentioned field1, field2 just for understanding that the file has 2 fields.

In the above file field1 and field2 are the columns in a csv file.
just for understanding, a1 is the first value in line1 in field1(column) and b1 is field2(column) value in line1 respectively.
I am looking for a matching criteria below:
By looking we can say that b1,b2,b3 are values in filed2(column) which are not found in field1(column). So I need print these not matched values of field2 in field1 to a output file. Probably I think I need help on looping foreach . Like every value in if ($field1 ne $field2) which should be looped to get the resulting set. If I can get help in completing the code it would be great.

I have the code done in perl. But since I am working with thin client, I cannot install perl in my work station. It is winows and hence I can only get my work done by windows MS-dos batch script.

I am not a dos guy and it would be great if anyone can help with a simple dos script for the above scenario.

Thanks...

Get your answer NOW

20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. Adam314745,483
2. ozo446,123
3. mrjoltcola179,834
4. FishMonger114,110
5. nemws1103,172
6. Tintin97,976
7. kawas63,130
8. climbgunks59,420
9. bounsy57,280
10. lwadwell54,350
11. Fairlight2cx40,548
12. vikaskhoria30,130
13. marchent27,180
14. oleber24,620
15. teraplane18,300
16. oocyte18,000
17. DropZone17,850
18. David_Bo...15,169
19. oklit14,760
20. Fero4514,286
21. evilrix13,748
22. tdlewis13,700
23. ahoffmann12,550
24. kevin_u11,380
25. suhasbha...11,022

1. ozo4,244,849
2. Adam3142,556,966
3. Tintin878,935
4. FishMonger620,501
5. kandura579,965
6. mjcoyne531,016
7. jmcg517,810
8. teraplane392,888
9. maneshr385,976
10. manav_m...338,348
11. clockwatc...262,862
12. ahoffmann231,362
13. rj2211,481
14. mrjoltcola179,834
15. davorg153,165
16. Tim_Utsc...113,107
17. shlomoy109,110
18. suhasbha...104,630
19. nemws1103,172
20. kawas101,161
21. gripe98,559
22. hielo90,420
23. nedfine83,157
24. Perl_Diver82,106
25. lwadwell79,191

File manipulation using Windows MS- DOS-Batch

Asked by pal2k in Perl Programming Language, MS DOS

Tags: Windows MS-Dos batch script

About this solution