Removing spaces from column names

[hale_52372]

Good Afternoon,

I am working on a database that has a large number of column names,  with spaces in them.

I  would like to set up a Global Rule to remove or replace all the spaces in column names  I was wondering if we could use the replaceChars command in the Expression builder.

However  I can not find any examples of the syntax of how to do this.  Has anyone been able to successfully do this?

Thank you 

Richard

[Pedro_Lopez · Accepted solution]

Hi Richard,

Thanks for reaching out. 

You can use the replace() function under the Global Rules --> Expression Builder --> Functions --> Strings --> Replace(X,Y,Z) 

Trying something quick here I could replace the spaces with empty characters by using this expression:

replace($AR_M_SOURCE_COLUMN_NAME,' ','')

You can also find more info here:

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedEMReplicate/Custom...

Hope this helps, let us know if this is what you're to achieve.

Regards,

Pedro

[hale_52372 · Accepted solution]

Hello Pedro,

Thank you for the help,  that worked first time .

Thanks

Richard