write number next to each other + return value 0/1
2 views (last 30 days)
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.
More Answers (1)
ILoveMATLAB on 15 Jun 2022
Edited: ILoveMATLAB on 15 Jun 2022
(Forgot to submit as an anwser)
For your first question.
- Convert each column of interest to an array of strings. sCol1 =strings(T.hod)
- Concatenate all the strings arrays using the + operator T.ID = sCol1 + sCol2+ sCol3
For your second question
ID_H = double(ID>5);