How to concatenate an array of numbers without for loop
2 views (last 30 days)
Show older comments
Hi, I have an array of integer numbers A = [1, 2, 3]. I would like to concatenate the numbers for use in SQL statement like '(1, 2, 3)'. How to do that without a for loop? Thanks.
0 Comments
Accepted Answer
Stephen23
on 22 Mar 2018
>> A = [1,2,3];
>> str = sprintf(', %d',A);
>> str = sprintf('(%s)',str(3:end))
str = (1, 2, 3)
0 Comments
More Answers (1)
Guillaume
on 22 Mar 2018
A = [1 2 3];
sprintf('(%s)', strjoin(compose('%d', A), ', '))
3 Comments
Guillaume
on 22 Mar 2018
compose was introduced in version R2016b. (You should say in your question if you're several versions behind).
In earlier versions, you can replace compose by the undocumented sprintfc:
sprintf('(%s)', strjoin(sprintfc('%d', A), ', '));
Or use Stephen's method of using sprintf then removing the initial ', '.
See Also
Categories
Find more on System Composer in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!