MATLAB: How to get rid of empty space and unit in the output

text file

Hello,

I have created a little code that opens 1×1 table(can not change the form in the .txt file) and stores a particular value. However the output is adding on the white spaces and [km]. How do I get rid of that? I just want the number to appear.

Here is my code:

filename = ('C:\Users\creid\Desktop\STK_doc.txt')
opt = detectImportOptions(filename)
A = readtable(filename, opt)
X = A(38,2)

and here is the output:

 '-712.419553              [km]'

I have also uploaded a snippet of the txt file

Best Answer

The following will parse your example file correctly for me:

A = readtable('example.txt', ...
              'Format', '%s%f%s', ...
              'Delimiter', {'\t', ' ', '=', '[', ']'}, ...
              'MultipleDelimsAsOne', true, ...
              'HeaderLines', 6, ...
              'ReadVariableNames', false)

Related Solutions

MATLAB: How to separate a comma separated .txt file with 216X1 cell into a 216X2 cell

You can textscan with a format of '%*s(%[^,],%[^)])' . The output of that would be a 1 x 2 cell array each of which is a cell array of strings. You can then combine those into an N x 2 cell array using []

fid = fopen('YourText.txt', 'rt');
datacell = textscan(fid, '%*s(%[^,],%[^)])');
fclose(fid);
Result = [datacell{1}, datacell{2}];

MATLAB: How to read a text file and import a part of it into matlab.

fmt=[repmat('%f',1,8) %*[^\n]'];  % 8 values, skip rest of line format string
fid=fopen('yourfilenamehere');    % open the file; return file handle
data=cell2mat(textscan(fid,fmt,38,'collectoutput',1)); % read; repeat format 38 times
fid=fclose(fid);                  % close file
% do whatever w/ data here...

NB: I went ahead and wrapped the textscan call in cell2mat to return a double array. I assumed delimiter one of the default; if something else you'll need to fixup to match.

See

doc textscan % for details, examples, etc., ...

Or, option B:

Use the data import tool from the User Interface that (I think) will let you select an area to import from the file...not sure how it will do with such a long file but presume it'll handle it.

Best Answer

Related Solutions

MATLAB: How to separate a comma separated .txt file with 216X1 cell into a 216X2 cell

MATLAB: How to read a text file and import a part of it into matlab.

Related Question