Unanswered

string() removes spaces from JSON values

(0) Share

Report

Posted on by jiwhite

498

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)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

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 498 on at

Like (0)

Report

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