replce all hyphens(-) in .txt file with 0

Hi
I am having numeric data in the form of 10*8 array in .txt file. The data is having 2 rows of hyphens which are causing problem in reading this data. I want to raplace hyphen(-) with zero (0).
Again one thing as data is having negative numbers also, so we have to replace -,(hyphen followed by comma which is delimiter) with 0, sothat negative numbers will remain intact.
So how can I do this replacement? Something like 'regexprep'.. but I want to replace all hyphens in .txt file.
Thanks in advance.

3 Comments

Provide an example and then we can start from there.
To cross-check: the hyphen-comma should be replaced by zero-comma ?
@ Walter: yes you are absolutely right..

Sign in to comment.

 Accepted Answer

Suppose that you have test file:
1.0-, 2.0
1.2-, -2.3
-1.4-, 2.6
code:
fid1 = fopen('test','r');
fid2 = fopen('test_copy','w');
tline = fgetl(fid1);
while ischar(tline)
tline = strrep(tline,'-,','0,');
fprintf(fid2,'%s\n',tline);
tline = fgetl(fid1);
end
fclose(fid1);
fclose(fid2);

2 Comments

Thanks for response.
But my data is not like you have taken. My data looks like
1, 2.3, 37, -, -4, 2
2, -1.7, -, -, 25, 6
3, -12, -, -, -5.4, 2
After some modification your code works perfectly well for my need..
Thank you.

Sign in to comment.

More Answers (0)

Categories

Community Treasure Hunt

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

Start Hunting!