cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kabilesh
Resolver I
Resolver I

Convert CSV to Excel with replace single quote ' delimiter

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?

 

Kabilesh_0-1670103061556.png

 

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @Kabilesh ,

 

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

vxiaochenmsft_0-1670204784752.png

// Open a .csv file 

 

vxiaochenmsft_1-1670204832286.png

replace(string(outputs('Get_file_content_using_path')?['body']),'''','')
 
vxiaochenmsft_2-1670204865510.png

 

Best Regards,

Wearsky

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.

 

Kabilesh_0-1670566841111.png

 

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

 

Thanks

VK

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,351)