Modify text in a column

Dear all, I want to modify just the first column of a file, removing the letters and keeping the numbers. The columns contain string like d200n-h. How it is possible?

Thanks,

Marco

Answer 1

[Walter Roberson]

Assuming comma delimited:

S = fileread('YourFile.txt');
newS = regexprep(S, '^\D*(\d+)[^,]+(,.*$)', '$1$2', 'lineanchors', 'dotexceptnewline');

fid = fopen('YourNewFile.txt');
fwrite(fid, newS);
fclose(fid)

This should work even if there is "" around the string, but it will remove the "" if present.

[Marco Sette]

Thanks but the third line seems to have some problem

Error: File: filter_first_column.m Line: 3 Column: 13

Invalid expression. Check for missing multiplication operator, missing or unbalanced

delimiters, or other syntax error. To construct matrices, use brackets instead of

parentheses.

-------

S = fileread('results1bar.txt');

newS = regexprep(S, '^\D*(\d+)[^,]+(,.*$)', '$1$2', 'lineanchors', 'dotexceptnewline');

fid = fopen'test.txt');

fwrite(fid, newS);

fclose(fid)

[Walter Roberson]

Repaired.