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

Question

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

Abdullah Dhiab · Answer

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 Dhiab · Answer

thanks for replying would you plz file is ~50000 lines and there are 22files parsing will take long time i dont know how to optimize it?

Wim Sturkenboom · Answer

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)