Unanswered

string() removes spaces from JSON values

(0) Share

Report

Posted on by jiwhite

500

When I use string(object) to turn a JSON object into a string, it does not preserve all of the spaces inside string JSON values. Double spaces are reduced to single spaces. For example, "ANION: Chloride" becomes "ANION: Chloride" Is there any way to stop this from happening other than replacing double spaces with another character, then change them back at the final point of use? This is a serious bug.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi there,

I'd like to know more specifics of the steps you've taken where you're running into this scenario. I just tried string() and I also tried placing JSON with double spacing into a string variable (just so see), with the double spacing retained in both.

Thanks,

Rhia

Was this reply helpful? Yes No
jiwhite 500 on at

Like (0)

Report
Copy link

Link copied!

I create an object with a 2D array populated from an Excel file that has strings in the values. Some of our test parameters were named including double spaces years ago.

Then, pass it to a To-Do
This is how I get the test cells and convert the sensitive label in Office Script.
I also tried putting it in a string variable. Whether I pass the object directly or use string(object), the same thing happens. The double spaces in test names get replaced with single spaces. To get around it, I replace " " with "**" when creating the 2D array, then replace "**" with " " when using the 2D array to populate another Excel File.

Was this reply helpful? Yes No