Replace * by 1 in the entire file

[Anonymous]

Hi,

I have more than 10 metrics in the file that contains * and I would like to replace it by 1. One way and it's a tedious way to do it is to use REPLACE function. For example: replace(CKD3_PRACTITIONER_FAC_TOTAL_PATIENTS,'*','1') as CKD3_PRACTITIONER_FAC_TOTAL_PATIENTS.

However, I have to use it for every single metrics, which is too time consuming.

How can I  place the * in the entire file with less effort, like what we can do in Excel?

Thanks!

[tamilarasu · Accepted solution]

Hi Ze,

You have to use replace function for all the fields and no other way to replace it in a single go (as far as I know) but I might be wrong.