Remove zeros in a table?
조회 수: 15 (최근 30일)
이전 댓글 표시
Hey everyone,
I am having the following problem which I am struggling with for quite some time. I have a character array of strings - each consisting of two numbers and an underscore. (e.g. 09_13, 14_15, 08_07). In this format I can use them as a column in a table. However, preferably I would like to save the table as an xls sheet and remove all zeros (e.g 9_13,14_15,8_7). This way the entry length in each row would differ obviously. Is that even possible in a table?
Thanks
Laurie
댓글 수: 0
채택된 답변
Walter Roberson
2020년 6월 8일
regexprep(YourCellArray, {'^0+(?=\d)', '(?<=_)0+(?=\d)'}, {'', ''})
This takes care not to replace an all-zero sequence with emptiness -- e.g., '00_14' will be converted to '0_14' and not '_14'. The code can be simplified a little if it is certain that a string of all 0 will not be present.
The code does not assume that the values are 2 digit; the code could be simplified even more if it was certain that all values were 2 digit.
regexprep(YourCellArray, {'^0', '_0'}, {'', '_'}) %2 digit case only
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!