Concatenate strings and numbers

50 views (last 30 days)
Robert Demyanovich
Robert Demyanovich on 9 Mar 2022
Edited: DGM on 9 Mar 2022
I'm using the following code to try and create a "Range" for importing an excel spreadsheet into MATLAB. Instead of getting a single string, I am getting a 1x2 string for CoeffsRange. MaxRows is the number of rows in the Excel spreadsheet that contain data. Here's the code
String1=num2str(MaxRows)
CoeffsRange = ["H2:K" String1]

Accepted Answer

DGM
DGM on 9 Mar 2022
Edited: DGM on 9 Mar 2022
Strings and chars are different. Take care in how you combine them.
MaxRows = 10;
String1 = num2str(MaxRows) % a char vector
String1 = '10'
CoeffsRange = ["H2:K" String1] % [string char] -> string array
CoeffsRange = 1×2 string array
"H2:K" "10"
CoeffsRange = ['H2:K' String1] % [char char] -> char vector
CoeffsRange = 'H2:K10'
CoeffsRange = "H2:K" + String1 % string + char -> string
CoeffsRange = "H2:K10"
CoeffsRange = strcat("H2:K",String1) % or use strcat()
CoeffsRange = "H2:K10"

More Answers (0)

Community Treasure Hunt

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

Start Hunting!