Removing hyphen/dash from a string

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,'-','')
1 Like

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

Thank you so much @Sanjeeb2022

Thanks a lot @debapc