How to write column by column to text file

[trkece]

Hi all

I want to write the data into text file column by column

NAme, MArks, SEx
Rama, 95, M
Sri, 85. F

I am getting the output as
Name
Rama
Sri
MArks
95
85
Sex
M
F

Can any one tell me the way...........

[Eranga]

Since you are writing the content to a text file, you can do something like this.

Calculate the number of rows initially. Once the first column is written into the text file, move to next column and to beginning of the text file. Then read the each line and append the new stuff to is and write back to file.

But my advice is not to do this really. Reason is that process is bulky. Best way is to write the entire line at the same time.

I hope you retrieve data from a database, and the content in a DataTable. So it's easy to deals with line-by-line.

[trkece]

Thanx for the reply,
but I don't want some columns from that table, i want to select only some columns and write it to the new file,

can u pls tell me how to move to next column and beginning of the file ??

Pls help me out ......

[trkece]

can u pls help me out.................

[trkece]

I need to write particular excel columns to one notepad for my applicarion

so i need to column wise write to tat text file....... pls help me out

[gcalvin]

Hi all

I want to write the data into text file column by column

NAme, MArks, SEx
Rama, 95, M
Sri, 85. F

I am getting the output as
Name
Rama
Sri
MArks
95
85
Sex
M
F

Can any one tell me the way...........

The short answer is that you can't write to a text file column-by-column. Text files just don't work like that. So if you want to create a text file like that, you need to compose it one line at a time.

Write a sample out on paper, thinking about what you are doing step-by-step. Then come back and tell us what all the steps are, and we can help you turn that into Java code.

-Gary-

[trkece]

EmpId Name Designation Order
1 ABC Software Engineer 7/8/2010
2 DFG Sr Software Engineer 7/15/2010
3 LOI Team Leader 9/1/2010
4 LKJ Project Manager 9/1/2010
5 QWE Software Architect 8/23/2010
This is in Excel, I want Name and Order columns in csv file with some delimiter like dis

Name, Order
ABC,7/8/2010
DFG,7/15/2010
LOI,9/1/2010
LKJ,9/1/2010
QWE,8/23/2010

for me i am getting output in the same colum like dis

Name
ABC
DFG
LOI
LKJ
QWE
Order
7/8/2010
7/15/2010
9/1/2010
9/1/2010
8/23/2010


Pls help me out..........

[Eranga]

Thanx for the reply,
but I don't want some columns from that table, i want to select only some columns and write it to the new file,

can u pls tell me how to move to next column and beginning of the file ??

Pls help me out ......

Sorry for the late reply.

So if you want to filter only few columns, rather using "SELECT * ... " specify all columns you want and filter.

[Eranga]

This is in Excel, I want Name and Order columns in csv file with some delimiter like dis

How did you read the excel file. You have to query it. As I told you in my previous post change the query appropriately first of all. Then you can create the line at the same time, that you want to write into text file.

[Eranga]

Write a sample out on paper, thinking about what you are doing step-by-step. Then come back and tell us what all the steps are, and we can help you turn that into Java code.

-Gary-

That's pretty good Gary. I feel too that OP doesn't tryout anything yet. :)