Export to a fixed width text file

2013 5 28
2 个回答
回答已采纳
5 次查看（30 天）

0 个投票

Hi. I have a fairly simple problem, but haven't figured out how to solve it.
I would like to convert a cell array to a text file with fixed width columns. For example, the first row might contain a mixture of strings and numbers:
's09' 1111222003 321 'P' 'ehz'
and I want to have five spaces between the first and second columns, seven spaces between the second and third, and 3 spaces between the third and fourth. The reason for this is because I am converting the data into a very finicky format.
Thanks for any help in advance.

请先登录，再回答此问题。

 采纳的回答

Jonathan Sullivan
Jonathan Sullivan 2013-5-28
编辑：Jonathan Sullivan 2013-5-28

0 个投票

Use sprintf / fprintf
Here is an example of making everything 16 characters wide:
A={'s09' 1111222003 321 'P' 'ehz';'z09' 1011222003 321 'O' 'edz'};
A=cellfun(@num2str,A,'Un',false)
for ii = 1:size(A,1);
B{ii} = sprintf([repmat('%16s',1,size(A,2)) '\n'],A{ii,:});
end
B = cat(2,B{:})
The number (16) between the % and the s determines the width that it will print out the entry. For more information type
help sprintf
doc sprintf
or
help fprintf
doc fprintf

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Jesse Hutchinson
Jesse Hutchinson 2013-5-28
编辑：Jesse Hutchinson 2013-5-28
Thanks a bunch. I ended up choosing to keep the string and number data separate and used fprintf to generate my text file. This is the final bit of code:
[nrows,ncols] = size(pickcat);
filename = 'test.arrival';
fid = fopen(filename,'w');
for row=1:nrows
fprintf(fid,'%-6s %17.5f %8d %8d %8d %8d %-8s %-8s %-1s %6.3f %7.2f %7.2f %7.2f %7.2f %7.2f %7.3f %10.1f %7.2f %7.2f %-1s %-2s %10.5g %-1s %-15s %8d %17.5f\n',pickcat{row,:});
end
fclose(fid);
As you can see, I had quite a complex data set! Thanks so much for the help.

请先登录，再进行评论。

更多回答（1 个）

Iman Ansari
Iman Ansari 2013-5-28

0 个投票

A={'s09' 1111222003 321 'P' 'ehz';'z09' 1011222003 321 'O' 'edz'};
A=cellfun(@num2str,A,'Un',false)
B=strcat(A(:,1),{' '},A(:,2),{' '},A(:,3),{' '},A(:,4),A(:,5))

2 个评论
显示 无 隐藏 无

Jesse Hutchinson
Jesse Hutchinson 2013-5-28
That seems to work great. Unfortunately, the character length on the values in some of my columns vary.
I am trying to think of a way to have a set column width (say, eight spaces for the first column) even though the value written within the first column may vary between 3 and 5 characters, while the rest need to be blank.
Iman Ansari
Iman Ansari 2013-5-28
编辑：Iman Ansari 2013-5-28
A={'s09' 1111222003 321 'P' 'ehz';'ere09' 11222003 31 'O' 'dz'};
for i=1:2
B(i,:)=sprintf('%-5s %-12d %-3d %-s %-3s',A{i,1},A{i,2},A{i,3},A{i,4},A{i,5})
end

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Standard File Formats 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by