Convert CSV to Excel with replace single quote ' delimiter

[Kabilesh]

Hi,

I have a set of csv data which has single quote at the start and end as well. While converting it to the Excel leading single quote gets hidden due to excel significance. In the set of csv data only some values has leading single quote because of that i cannot use text to column function as well. 

My aim is to do sum for all columns which i cannot do because of some leading single quote.

Can anyone help me with this?

[v-xiaochen-msft]

Hi @Kabilesh ,

Let's say you want to remove the single quote from csv file.

// Open a .csv file 

replace(string(outputs('Get_file_content_using_path')?['body']),'''','')

Best Regards,

Wearsky

[Kabilesh]

Hi @v-xiaochen-msft 

Thanks for your help with replace actiity.

In addition, as I did the replace function, some data with general data type are converting to date datatype.

It would be great if you can help me with this.

Thanks

VK