Is it possible write on txt file and then convert it to csv?
1 view (last 30 days)
Show older comments
Anita Coletta
on 30 Oct 2020
Edited: Gouri Chennuru
on 3 Nov 2020
Hello everybody!
It's me again; today I have new problem: we're trying to add 3 char array, because we need it for another software. We try with this part of code:
text={'Start:,0,';'Length:,1200,';'Sample Rate:,100,'};
sign=cellstr(text);
sign2=num2cell(sign1(:,1));
SIGN={[sign;sign2]};
SIGN2=cell2table(SIGN{1,1});
SIGN3=table2array(SIGN2);
writecell(SIGN{1,1},'output.csv')
But there's a problem with txt file, because there're ' " ' and they don't run the software that we need to use.
We've tried with another code
sign1=0.00001*sign1;
dlmwrite('NEW.txt',sign1,'precision','%.f,');
load NEW.txt;
NEW=NEW(1:4096);
writematrix(NEW,'output1.csv');
but, in this case, we don't know how to insert 3 char rows in txt file.
Can someone help us, please?
2 Comments
Mathieu NOE
on 30 Oct 2020
hello Anita
sorry I don't understand your problem.
But there's a problem with txt file, because there're ' " ' and they don't run the software that we need to use.
you want to add 3 char (what ? the ' " ' ? ) array where ? in the file name ? in the csv file ?
what are the dimensions of your input data ? (sign1)
would be helpfull if you can define :
1/ your inputs : sign1,
2/ a template of how you want to have your output data / output file organized...
Star Strider
on 30 Oct 2020
The table approach is appropriate and preferable. Keep it that way!
Accepted Answer
Gouri Chennuru
on 3 Nov 2020
Edited: Gouri Chennuru
on 3 Nov 2020
Hi,
You can maintain the table and you can use the “writetable” function in MATLAB to write the table to a comma delimited text file.
Hope this Helps!
0 Comments
More Answers (0)
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!