
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Removing spaces from column names
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
Hope this helps, let us know if this is what you're to achieve.
Regards,
Pedro

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Pedro,
Thank you for the help, that worked first time .
Thanks
Richard

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
Hope this helps, let us know if this is what you're to achieve.
Regards,
Pedro

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Pedro,
Thank you for the help, that worked first time .
Thanks
Richard
