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

1 view (last 30 days)
Zuzana Pániková on 14 Jun 2022
Commented: Zuzana Pániková on 17 Jun 2022
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 CommentShowHide None
ILoveMATLAB on 14 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);

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)
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.

### More Answers (1)

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);
Zuzana Pániková on 17 Jun 2022
Thank you,now it works

R2022a

### Community Treasure Hunt

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

Start Hunting!

Translated by