use regexp to split table columns?
Mostrar comentarios más antiguos
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 comentarios
Azzi Abdelmalek
el 24 de Ag. de 2016
post a sample of your data
MA
el 25 de Ag. de 2016
Respuesta aceptada
Más respuestas (0)
Categorías
Más información sobre Text Data Preparation en Centro de ayuda y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!