Fix dynamically named variables
5 views (last 30 days)
Show older comments
I am working with data from another program that dynamically names table variables. This needs to be corrected to make my script work.
Currently Vartable.Properties.VariableNames=
{'VarA_f01_01/01/2021'} {'VarB_f01_01/01/2021'} {'VarC_f01_01/01/2021'}
I would like this to look like
{'VarA'} {'VarB'} {'VarC'}
Is there a way to do this for multiple variable names without a bunch of if contains statements?
The variable names are in a standardized format but the numbers dates and letters will change. Sometimes certain variables will not be present and only VarA and VarC may be in the table which further complicates things.
Any help is appriciated.
2 Comments
Jeff Miller
on 3 May 2021
It's hard to tell from these examples what the full range of "before" and "after" variable might be. For the names shown, for example, it would be sufficient to rename each variable with the part of its original name preceding the first underscore. Would that always work?
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Data Type Conversion 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!