	[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!

8.3

How can I use a batch file to parse multiple multi-line text files and output into CSV format?

Asked by gp423 in Miscellaneous Programming, MS DOS, Windows Batch Scripting

Tags: DOS, batch, CSV, text file

I am trying to create a batch process that will parse multiple multi-line text files (samples attached) and output their contents into a single pipe-delimited CSV file. I can't use commas as delimiters in the output because the baseline data may contain commas. Unfortunately, I am a novice when it comes to programming so any assistance would be greatly appreciated.

Here is some sample content from a couple of the attached files:
=====
1-12345-12345-98765-98765
COMPANY ONE
Options: Debugger, SQL Optimizer, PL/Sql Kb

=====
9-99999-88888-77777-66666
COMPANY ONE

=====
8-88888-77777-66666-55555
123456-7890

=====
0-11111-77777-33333-22222
COMPANY THREE
Options: none

=====

The first line is a serial number or product key. The second is the internal organization name which purchased the license. The third line may or may not exist, but is focused on a brief product description. The fourth line is either always blank or nonexistent. (The "=====" was used to designate different files and does not exist within the real data.)

Q: How can I take the content from each file and concatenate the data into a single line (per file) which is pipe-delimited, then append each additional file on subsequent lines?

View the Solution FREE for 30 Days

Attachments:

sample1.txt (87 bytes) (File Type Details)

sample file 1

sample2.txt (87 bytes) (File Type Details)

sample file 2

sample3.txt (40 bytes) (File Type Details)

sample file 3

sample4.txt (87 bytes) (File Type Details)

sample file 4

sample5.txt (38 bytes) (File Type Details)

sample file 5

sample6.txt (49 bytes) (File Type Details)

sample file 6

sample7.txt (40 bytes) (File Type Details)

sample file 7

sample8.txt (58 bytes) (File Type Details)

sample file 8

20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. Infinity0851,220
2. CodeCruiser43,598
3. abel41,336
4. ozo39,788
5. Idle_Mind32,809
6. Shift-332,420
7. Volox32,362
8. TheLearn...29,500
9. angelIII26,532
10. objects24,893
11. BlueDevilF...21,450
12. jkr20,900
13. evilrix20,200
14. jpaulino18,100
15. RobSamp...17,350
16. Dhaest17,186
17. emoreau16,895
18. mrjoltcola16,840
19. matthews...15,000
20. moorhous...14,850
21. robberbaron14,750
22. itsmeandn...14,695
23. Omego2K14,500
24. ragi001714,300
25. ToddBeau...13,632

1. cookre746,814
2. Interactive...699,539
3. Idle_Mind654,501
4. ozo431,265
5. Raisor403,292
6. jaime_oliv...387,063
7. nayernag...340,059
8. AlexFM330,806
9. Arthur_...318,698
10. sirbounty314,101
11. sunnycoder276,181
12. emoreau253,836
13. mlmcc241,731
14. Kavar234,568
15. angelIII233,636
16. pratap_r233,485
17. TheLearn...212,534
18. graye208,601
19. twalgrave205,843
20. julianH195,399
21. JesterToo185,484
22. RobSamp...173,080
23. gecko_a...166,943
24. bhagyesht164,069
25. Dhaest142,204

How can I use a batch file to parse multiple multi-line text files and output into CSV format?

Asked by gp423 in Miscellaneous Programming, MS DOS, Windows Batch Scripting

Tags: DOS, batch, CSV, text file

About this solution