write number next to each other + return value 0/1

2 views (last 30 days)
Hello,
i have a tablehave imported from Excel.
In the ID column I want the values ​​from hod + min + s + CasVSekundach but as text so that it doesn't add up for me (T.ID = (T.hod) + (T.min) + (T.s). It should look like in the first column: not 25 but 002525(h/min/s/CasVSekundach).
And I want to create a new column (ID_H), where the distance from the column according to criterion> 5 returns 0 and if = <5 returns 1
I try ID_H=(ID(ID>5)=1), but it doesn´t works...
Thank you for any help.
  1 Comment
ILoveMATLAB
ILoveMATLAB on 14 Jun 2022
Edited: ILoveMATLAB on 15 Jun 2022
For your first question.
  1. Convert each column of intrest to an array of strings. sCol1 =strings(T.hod)
  2. Concatenate all the strings arrays using the + operator T.ID = sCol1 + sCol2+ sCol3
For your second question
ID_H = double(ID>5);

Sign in to comment.

Accepted Answer

Jon
Jon on 14 Jun 2022
Let us say your table is called T, then you can use:
T.ID = string(T.hod) + string(T.min) + string(T.s) + string(CasVSekundach)
  8 Comments
Zuzana Pániková
Zuzana Pániková on 17 Jun 2022
T.ID = string(T.hod) + string(T.min) + string(T.s)+(T.CasVSekundach)
I got it, I'm slow. Thanks a lot for your help.

Sign in to comment.

More Answers (1)

ILoveMATLAB
ILoveMATLAB on 15 Jun 2022
Edited: ILoveMATLAB on 15 Jun 2022
(Forgot to submit as an anwser)
For your first question.
  1. Convert each column of interest to an array of strings. sCol1 =strings(T.hod)
  2. Concatenate all the strings arrays using the + operator T.ID = sCol1 + sCol2+ sCol3
For your second question
ID_H = double(ID>5);
  4 Comments

Sign in to comment.

Tags

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!