Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hello Pedro,
Thank you for the help, that worked first time .
Thanks
Richard
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
Hello Pedro,
Thank you for the help, that worked first time .
Thanks
Richard