How to parse a text file and write the result to an xls file?
Hi all i am a junior level SQL developer. I have a situation where I have a text file with 1100 lines of a search result with each line containing a file path and a stored procedure associated with that file. Each line has a structure like the one below:

abc\def\ghi\***.cs(40): jkl=******.*****.******, "proc_pqrst", parms);

Where abc\def\ghi\***.cs is file path of the file ***.cs. The stored procedure names begin with proc_ . I have to extract the ***.cs and the corresponding stored procedure name begining with proc_ and write them to a .xls file. Can some body help me in writing the parsing program to do this. Also can I get a detailed outline  on where should I write the code for c# and where should I compile it? This could be a great help as I don't have any knowledge of C#.

Thank you,
BK.

How to parse a text file and write the result to an xls file?
===

Hi all i am a junior level SQL developer. I have a situation where I have a text file with 1100 lines of a search result with each line containing a file path and a stored procedure associated with that file. Each line has a structure like the one below:

abc\def\ghi\***.cs(40): jkl=******.*****.******, "proc_pqrst", parms);

Where abc\def\ghi\***.cs is file path of the file ***.cs. The stored procedure names begin with proc_ . I have to extract the ***.cs and the corresponding stored procedure name begining with proc_ and write them to a .xls file. Can some body help me in writing the parsing program to do this. Also can I get a detailed outline  on where should I write the code for c# and where should I compile it? This could be a great help as I don't have any knowledge of C#.

Thank you,
BK.
