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

Using Replace to remove double quotes in the output

Hello there, 

 

I have a flow that triggers when a new CSV file is created in Onedrive folder, it will copy all the data from that CSV file into my sharepoint list. But i have one major problem. The CSV file is formatted as quoted CSV. It means every data in the file has (") double quotes in the beginning and on the end. Here is the Result below image. 

 

double quoted data in SP List. 

echodapogi_0-1614625534645.png

here is the sample CSV file of what it look like.

echodapogi_5-1614625883802.png

 

 

How can i remove those (") double quotes by using a replace expression in flow? 

 

Here is my flow. Note: i'm a newbie. somebody help me to put this flow. so please if somebody can guide me where to put the "Compose /replace expression" 

 

i tried this. Like replace (") with " "  empty. :  but its not working

 

replace(outputs('splitNewLine'),'"',' ')

 

 

another error i encounter is this

echodapogi_0-1614627026312.png

 

 

here is my flow.

echodapogi_1-1614625625844.png

echodapogi_2-1614625658257.png

 

echodapogi_3-1614625687013.pngechodapogi_4-1614625715583.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Community Champion
Community Champion

Hi @echodapogi 

 

You could probably do it right from the start? 

 

split(replace(outputs('Get_file_content')?['body'],'"',''),decodeUriComponent('%0A'))

 

No need for a space in the ''.

 

Otherwise it would be massive overhead at the create item stage, albeit it would be possible to apply it to each from the parse json during the create item stage.

 

DamoBird365_0-1614629210215.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

View solution in original post

2 REPLIES 2
DamoBird365
Community Champion
Community Champion

Hi @echodapogi 

 

You could probably do it right from the start? 

 

split(replace(outputs('Get_file_content')?['body'],'"',''),decodeUriComponent('%0A'))

 

No need for a space in the ''.

 

Otherwise it would be massive overhead at the create item stage, albeit it would be possible to apply it to each from the parse json during the create item stage.

 

DamoBird365_0-1614629210215.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

View solution in original post

StalinPonnusamy
Helper III
Helper III

I tried using compose and works fine using replace

replace(variables('Input Data'),'"','')

 

input : "testdata"

output: testdata

 

Can you please verify the doublequote? It shows but sometimes it really different symbol

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (37,679)