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:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

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

Hi

Try the below

Above compose expression is as follows:

replace(outputs('Compose'),',','","')

Was this reply helpful? Yes No
JohnWalkerGBG 2 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

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

Hi

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

Thanks

Was this reply helpful? Yes No