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

3 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
Sorry, I didn't understand the principle of the example attachment here on the site.
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.

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Tags

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!