Conversion of a Tab Delimited (.txt) file to Comma Delimited (.txt) file

Question

Hi I have to write a piece of code that let the user to select a Tab Delimited (.txt file). And then convert it to Comma Delimited (.txt file). (conversion to commas where a tab is find) any one there for help. thanks in advance. faraz akram

Jan Montano · Answer

It's ok faraz. :) You just need to use the trim() function of a string. outputLine += \ + elements[i].Trim() + \;

faraz akram · Answer

thanks a lot .JONES. I leant a lot from this.. cheers : )

faraz akram · Answer

Morning Jan... glad to get a solid response. one last thing ....... :( for instance the given output of ur code is as follow 19-07-2005PRE 3 it should be like 19-07-2005PRE3 thanks in advance BTW sorry to bothering u over n over as am not that senior in development.

Jan Montano · Answer

StreamReader reader = new StreamReader(@D:\jan	ab.txt); StreamWriter writer = new StreamWriter(@D:\jan\comma.txt); while (!reader.EndOfStream) { string inputLine = reader.ReadLine(); //string[] elements = inputLine.Split('	'StringSplitOptions.RemoveEmptyEntries); string[] elements = inputLine.Split('	'); string outputLine = ; for (int i = 0; i { outputLine += \ + elements[i] + \; } outputLine = outputLine.Substring(0 outputLine.Length - 1); // remove the comma at the end writer.WriteLine(outputLine); } reader.Close(); writer.Close(); *just ask if there's something confusing with the code.

faraz akram · Answer

hi :) nice to get response from you. well i try this but doen't seems to work out  note only   req for each word in txt file. abcdef should be abcdef StreamReader reader = new StreamReader ( @C:\comma.txt ); StreamWriter writer = new StreamWriter ( @C:\newfile.txt ); while (!reader.EndOfStream) { string inputLine = reader.ReadLine(); string [] lines2 = inputLine.Split( new char [] { ''  '
' } StringSplitOptions .RemoveEmptyEntries); writer.WriteLine(lines2); } reader.Close(); writer.Close(); waiting for ur response thanks

Jan Montano · Answer

Hi I could give you the code easily. But I want you to also learn. Try it first and see how you could make it work. You have to understand the code. string.Split function will do the job for you. All you have to do is research and try it first. Then Post what you have come up so far. I'll be very glad to assist you.

faraz akram · Answer

plz send me the code.... thanks

Jan Montano · Answer

use the Split function inputLine.split('	') this returns a string array. then all you have to do is modify each string with ' at the beginning and end.

faraz akram · Answer

One more thing plz.. each entity would be enclosed like---> 'abc' ------------------------------------- input---> abc 123 567 out put---> 'abc''123''567' ------------------------------------ thnaks

faraz akram · Answer

thanks a tons :) it really works and very to the point ....... faraz akram

Jan Montano · Answer

private static void Test5() { StreamReader reader = new StreamReader(@C:	ab.txt); StreamWriter writer = new StreamWriter(@C:\comma.txt); while (!reader.EndOfStream) { string inputLine = reader.ReadLine(); string outputLine = inputLine.Replace('	' ''); writer.WriteLine(outputLine); } reader.Close(); writer.Close(); }