Can you please help me to get the square root of the sum of squares of the second column in the text file ?

Hello everyone, Thank you for reading this query. I need some help to read the text file attached and replace the NaN with the 0 and also find the square root of the sum of squares for the second column and store the result to a certain variable. Can you help me with the code?

[James Tursa]

I don't see any attached text file.

[Adeline War]

Can you find it now?

[Walter Roberson]

@Adeline War

No, we cannot see the file yet.

[Adeline War]

@James Tursa@Walter Roberson It is attached now , I hope. Thank you

Answer 1

[Matt J]

Your attachment didn't make it, but assuming it's called yourFile.txt,

[~,col]=readvars('yourFile.txt');

result = norm(col(~isnan(col)));

[Adeline War]

File attached

[Matt J]

No, it isn't, but it shouldn't affect my proposed solution. Did you try it?

[Adeline War]

@Matt J Error!! Undefined function 'isnan' for input arguments of type 'cell'.

[Matt J]

T=readtable('output.txt');

col=str2double(T.value(T.value~="N/A"));

result = norm(col)

result = 0.7382

[Phenicia]

@Matt J This code worked. Thank you Matt

[Matt J]

@Phenicia assuming you are also @Adeline War,

You're quite welcome, but please Accept-click the answer to certify that.

[Adeline War]

@Matt J Thank you