Is there a way to split a table column containing text values as entries and return the newly split out contents as columns?
I have a table named Data with a column named TestID (Data.TestID). The following regexp command properly finds my text values and returns them:
OUT = regexp(Data.TestID, '(\w+-\w+)-\w{2}[-](\d+)\w*-','tokens')
Unfortunately, OUT is returned as a nx1 cell array where each cell contains a 1x1 cell array, each of these in turn contains a 1x2 cell array with my split strings inside. For example:
OUT{1,1}{1,1}
contains the two strings split out of the first entry of Data.TestID
Is there any way to split these strings so that OUT returns two columns that can be appended back onto Data?

댓글 수: 2

Azzi Abdelmalek
Azzi Abdelmalek 2016년 8월 24일
post a sample of your data
MA
MA 2016년 8월 25일
I ultimately found a solution (posted here)

댓글을 달려면 로그인하십시오.

 채택된 답변

MA
MA 2016년 8월 25일

1 개 추천

I ultimately found a solution using 'names' to split the output into a structure that I could convert into a table:
OUT = regexp(Data.TestID(:,1), '(?<Name1>\w+-\w+)-\w{2}-(?<Name2>\d+)\w*-\w{2}', 'names');
OUT = [OUT{:}];
OUTTable = struct2table(OUT);
this let me append OUTTable to Data using:
Data = [Data OUTTable];

추가 답변 (0개)

카테고리

도움말 센터File Exchange에서 Text Data Preparation에 대해 자세히 알아보기

제품

태그

질문:

MA
2016년 8월 24일

댓글:

MA
2016년 8월 25일

Community Treasure Hunt

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

Start Hunting!

Translated by