i need a c# code to parse below lines into csv formate

Abdullah Dhiab

Hello,
i need your kind help.
i need to format below lines into CSV format, file size in MB ~4MB.

--------------
JD2BSC01 BCF-0441 ENVIR 2014-12-24 08:00:34.70
*** ALARM
ENABLED
(41431) 7409 EXTERNAL AL 9
COMMERCIAL POWER FAILURE
JD2BSC01 BCF-0441 ENVIR 2014-12-24 08:00:54.72
... CANCEL
ENABLED
(41431) 7409 EXTERNAL AL 9
COMMERCIAL POWER FAILURE

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdullah Dhiab11y ago
i made a script with redhat shell but its not, so i need to do it on c#, output to be same as below:

-------------
41431;ALARM;JD2BSC01 BCF-0441 ;ENVIR;7409;***; EXTERNAL AL 9;2014-12-24:08:00:34.70
41436;ALARM;JD2BSC01 BCF-0341 BTS-0707 TRX-001;QUAL;7744;**; EXCESSIVE TCH INTERFERENCE;2014-12-24:08:03:24.45
41437;ALARM;JD2BSC01 BCF-0233 BTS-0962 TRX-003;QUAL;7744;**; EXCESSIVE TCH INTERFERENCE;2014-12-24:08:03:24.45
41440;ALARM;JD2BSC01 BCF-0441 ;ENVIR;7409;***; EXTERNAL AL 9;2014-12-24:08:05:25.00
Abdullah Dhiab11y ago
thanks for replying, would you plz
file is ~50,000 lines and there are 22files
parsing will take long time, i dont know how to optimize it?
Wim Sturkenboom11y ago
How many lines does your example represent? Two? Or more?

Anyway, it looks like fixed-width fields and you can use the TextFieldParser class to parse the fixed width lines.

Next you can write the resulting fields to file using one of the many csv code samples on the web; my favorite is the one by Andreas Knab (write: http://knab.ws/blog/index.php?/archives/3-CSV-file-parser-and-writer-in-C-Part-1.html, read: http://knab.ws/blog/index.php?/archives/10-CSV-file-parser-and-writer-in-C-Part-2.html)