Needing to replace a comma with "," and the output field always contains \",\"

(0) Share

Report

Posted on by JohnWalkerGBG

Been researching and testing all the solutions I can find to try and work this out. Sadly no luck

Have a text field in excel that has several values in it separated by comma e.g. 123456, 545454, 999999

These values are needed to be passed into a JSON request and need to be formatted so that the commas are replace with "," - so the outcome I am trying to get is 123456","545454","999999 (the first and last double quotes are dealt with in the JSON request

What I get is 123456\",\"545454Z\",\"999999

I've tried lots of suggestions on here to add a step after I get this output to

Try and remove using replacing with DecodeURIcomponent - %5C (the \)

Try and remove using replace \" with "

Try and remove using replace \ with '' (nothing)

Would anyone have ideas on how I can solve please? Happy to be pointed to suggestions for further research

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Try the below

Above compose expression is as follows:

replace(outputs('Compose'),',','","')
JohnWalkerGBG 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Abm abm

That was one of the options I had tried with the input data and sadly that didnt work

Initially it did appear to work and the output on the run showed this image below

When I looked at show raw outputs - the data that was passed to where I need to use it looked like this
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Thanks for your reply. I need to see the flow and have a look.

Thanks