How do I remove hyphen/dashes from a string values of a column in query or in calculated field.
For example- Original Column field value= 2023-07-26
I want a new column which will store the Expected results= 20230726
Thank you.
How do I remove hyphen/dashes from a string values of a column in query or in calculated field.
For example- Original Column field value= 2023-07-26
I want a new column which will store the Expected results= 20230726
Thank you.
Hi @dsahu - You can use the replace function as below in a calculated field:
replace(DateString,'-','')
Hi @dsahu - @debapc is correct, you can find the replace documentation in the below link - Replace - Amazon QuickSight
It is always good to go through the document so that you have a clear idea why you are using the function.
Regards - Sanjeeb