How to replace spaces with underscores in all variable names of a table?

Hi,

I am searching for a solution to replace all ' ' (spaces) with underscores '_' in a range of variable names of a table. As the tables vary and the variable names change likewise, I need to find a more universal solution than changing the header names with

X.Properties.VariableNames = {'..' '...'}

I have tried regexprep and strrep, but couldn't find a way to make it work.

Thank you very much in advance!

Judith

Answer 1

[Walter Roberson]

X.Properties.VariableNames = regexprep(X.Properties.VariableNames, ' ', '_'))

[JMSE]

Perfect, thank you very much!