How to turn empty spaces into "0" when converting .TXT file into a .CSV file?

1 次查看（过去 30 天）

Thomas McCutcheon 2022-4-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1696840-how-to-turn-empty-spaces-into-0-when-converting-txt-file-into-a-csv-file

关闭： Thomas McCutcheon 2022-4-18

I have joint angle data from a motion capture study. Sometimes there are gaps in the data for multiple reasons but it needs to read as "0" for propper analysis. Does anyone know a way to convert the .txt file to a csv file as well as turning the empty spaces into zeroes? I cannot get it to work when I try to use the "load" function and the "fopen" function but there is also a good chance I am doing it wrong. I have attached the raw data and what I would like line 1 to look like.

Any help is appreciated. Thank you!

2 个评论
显示无隐藏无

Scott MacKenzie 2022-4-14

Are you sure there are gaps? If I open your file in Excel using "tab" as the delimiter, the data are properly aligned in each column, with a label for each column, and without any missing data: