Hi there, really need assistance parsing / converting this output (coming from exec-node). The best I was able to achieve using a string-node is to isolate a single variable. The output is always these 6 lines. [image] Or I can get simplified to [image] Trying to get an object in this for…

Your exec node output has a newline at end this should remove it also [{"id":"550f90e56d2a20f8","type":"inject","z":"452103ea51141731","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":…

Can you return [{"BUY": 7, "SELL": 10, "NEUTRAL": 9}, {"BUY": 7, "SELL": 10, "NEUTRAL": 9}, {"BUY": 7, "SELL": 10, "NEUTRAL": 9}] As that would be a valid JSON string, which could be passed through a JSON node. Single quotes are not valid in a JSON [edit] If not this should work on your initial …

Using the node-string I can replace the single quotes and append brackets, but still need commas. [image]

Can you post text, so i can edit. You need commas were i put them at end of each line, apart from last.

This is how it's coming in raw 5m {'RECOMMENDATION': 'SELL', 'BUY': 2, 'SELL': 15, 'NEUTRAL': 9} 15m {'RECOMMENDATION': 'STRONG_SELL', 'BUY': 0, 'SELL': 16, 'NEUTRAL': 10} 30m {'RECOMMENDATION': 'SELL', 'BUY': 3, 'SELL': 14, 'NEUTRAL': 9} 1h {'RECOMMENDATION': 'SELL', 'BUY': 2, 'SELL': 15, 'NEUTRAL…

This is how it's coming in raw Question is why you get this weird output, the program producing it should be able to produce json as well, as it already partly does it.

it's calling on an external python scripts, that's how it come in, I have no control over it

Hi, just tried the flow ... getting "Unexpected end of JSON input" error

Node-RED

Node-RED Forum

Parsing / Converting String to Object

General

system Closed 4 December 2022 22:35 13

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
JSON on exec nodes General	4	523	11 August 2021
Converting String into JSON Object General	10	4229	25 December 2022
String Array from Exec Node to JSON Object General	5	87	19 December 2024
Converting string payload into JSON General	8	22932	14 September 2019
Object vs strings - extract a value from a split General	6	2220	20 March 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Parsing / Converting String to Object

Related topics