Convert CSV to TXT without changing data properties

66 ビュー (過去 30 日間)
James 2020 年 3 月 12 日
コメント済み: Walter Roberson 2020 年 3 月 12 日
I have a CSV file that contains random values, all of them being decimals. Some of them have one decimal value while others have 6 or 7 decimals. When I convert them to txt, values are stored as follows.
How can I convert the csv without changing the actual value and keeping the precise decimal points (comma delimited)?
Thanks in Advance!
  3 件のコメント
Walter Roberson
Walter Roberson 2020 年 3 月 12 日
Csv does not store as scientific notation and pop up to full decimal places. However, Excel does that, and in MATLAB if you view the variable with the variable browser matlab does that unless you set the variable browser to use g format. Preferences can change the default browser format.



Walter Roberson
Walter Roberson 2020 年 3 月 12 日
You do what I already told you to do, and even provided code details for: manipulate the file as text instead of as numeric.
I guarantee you that if you treat the file as numeric that you cannot meet your goal of preserving the original number of decimal places -- not unless each different column has its own fixed number of decimal places. Which I can see from your sample is not the case.
  1 件のコメント
James 2020 年 3 月 12 日
編集済み: James 2020 年 3 月 12 日
That question was not entirely related to this but this is absolutely true! I should've been more cautious because your approach is much better than what I was trying.
Thanks a lot, Walter!
#TIL with the experts here is always amazing.


その他の回答 (1 件)

Piyush Lakhani
Piyush Lakhani 2020 年 3 月 12 日
Hi James,
Following way might be work for you.
x=csvread('filename.csv','Row_offset','column_offset'); %if your file has text then give offset for column or row
content=sprintf('%f, %f, %f, %f, %f, %f, %f \n',x); % put %f number of times same as number of columns,
% Insted of %f you can set the decimals you wants like eg. %5.6f
fId = fopen(fId, 'w') ;
fwrite( fId, content ) ;
fclose( fId ) ;
  5 件のコメント
Walter Roberson
Walter Roberson 2020 年 3 月 12 日
content=sprintf('%.0f, %.0f, %.1f, %.1f, %.1f, %.6f, %.6f \n',x.');
to deal with multiple rows


Community Treasure Hunt

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

Start Hunting!

Translated by