MATLAB Central Newsreader - create a table using .txt file

create a table using .txt file

ashish — Sun, 23 Nov 2008 19:27:02 -0500

I have loaded .txt file and stored it in a variable. How do i create a table using that data? I need to label each column and give it a title.
Below is the .txt data
1732 2 22
1777 12 15
1778 1 20
1564 4 23
1592 2 21
1592 4 2
2000 2 1
2008 11 3
2009 1 15

Thank you.

Re: create a table using .txt file

Walter Roberson — Sun, 23 Nov 2008 19:34:23 -0500

ashish wrote:
> I have loaded .txt file and stored it in a variable. How do i create a table using that data? I need to label each column and give it a title.
> Below is the .txt data
> 1732 2 22
> 1777 12 15
> 1778 1 20
> 1564 4 23
> 1592 2 21
> 1592 4 2
> 2000 2 1
> 2008 11 3
> 2009 1 15

Which version do you have? If you have R2008b, you can use the (newly official)
uitable(); you can probably use num2cell() to get the proper cell array to feed in.
(A usable uitable might also be in R2008a; before that I believe the uitable
was undocumented and had notable problems.)

--
.signature note: I am now avoiding replying to unclear or ambiguous postings.
Please review questions before posting them. Be specific. Use examples of what you mean,
of what you don't mean. Specify boundary conditions, and data classes and value
relationships -- what if we scrambled your data or used -Inf, NaN, or complex(rand,rand)?

Re: create a table using .txt file

Andres — Sun, 23 Nov 2008 20:04:02 -0500

"ashish " <ashishtx@hotmail.com> wrote in message <ggcaq6$h65$1@fred.mathworks.com>...
> I have loaded .txt file and stored it in a variable. How do i create a table using that data? I need to label each column and give it a title.

By "table" you mean a new file? Then just use fprintf.

d = [1732 2 22
1777 12 15
1778 1 20
1564 4 23
1592 2 21
1592 4 2
2000 2 1
2008 11 3
2009 1 15];

titles = '"Title1","Title2","Title3"';

% write to file with pc type line breaks ('\r\n'):
fid = fopen('c:\mytable.csv','w');
fprintf(fid, '%s\r\n', titles);
fprintf(fid, '%f,%f,%f\r\n', d);
fclose(fid)

Such a csv file should open correctly in standard spreadsheet software, like OpenOffice. If it is MS Excel, of course, you may look at xlswrite and use a single cell array.

Regards
Andres