Good afternoon everyone, In the data structure that I have in the image below, I need to join the string that is in the field "filename" of all the positions of the array ("rowSelection") in a single string separated by blank space. I've tried with the join node and with a function node that joins…

Ok tested now and the expression worked here is a example [{"id":"496ff00c.abfe5","type":"inject","z":"b779de97.b1b46","name":"","props":[{"p":"payload"},{"p":"ui_control","v":"{\"rowSelection\":[{\"id\":1,\"filesize\":\"82K\",\"filename\":\"datalog--2021-6-1--13-27--0.csv\"},{\"id\":2,\"filesize\…

in a change node using JSONata expression :j $join($$.ui_control.rowSelection.filename, " ") should work un tested as you supplied no data to test with.

Thanks @E1cid , I didn't add the rest of the flow because I thought I would add more stuff. However I let you down my flow. I've already put the change node that you referred to (I named the node "join_file_names"), I've put a debug node in front of it but the result hasn't changed. I'm probably …

[image] MiguelSoares: [image] I need a copyable version of this so I can paste it in to test. If you go to debug panel use the copy value button to copy the data and paste here between backticks, use the </> button

You have not supplied the data requested , as said i need the info in the image in a copyable format. Please goto the debug pane and use the copy value button on the ui_control object. the button will appear when you hover the mouse where my cursor is in image below [Screenshot_20211026-165328]

[image] MiguelSoares: I need to join the string that is in the field "filename" of all the positions of the array ("rowSelection") in a single string separated by blank space. Are you sure you really need to do that? What are you going to do with it?

Hi @Colin The idea is to have the name of all selected files from a table, separated by blank space and in a single string to feed a command to eliminate files from an rpi.

I think I would probably use a node red fs node to do that, deleting them one at a time. But if you want to do them all at once then that is fair enough.

Thank you very much @E1cid I made the necessary changes for the case of my flow and it is working properly.

Join specific array field in a string separated by blank space

General

MiguelSoares 26 October 2021 15:55 7

{"callback":"rowSelectionChanged","rowSelection":[{"id":1,"filesize":"82K","filename":"datalog--2021-6-1--13-27--0.csv"},{"id":2,"filesize":"142K","filename":"datalog--2021-6-1--13-33--0.csv"}]}

I'm sorry but as I'm not very experienced I didn't understand.
I think I'm giving you the value of the ui_control object now

Topic		Replies	Views
Can the JOIN node be with 'reduce sequence' on strings (YES)...and should it?(Maybe...) General	15	1088	6 October 2021
How to create payloads (strings merged/concatenated from array objects) from Excel data? General mqtt	20	1773	10 October 2022
Combine two arrays based on line number General	14	1127	20 August 2020
Missing values after passing through the csv node General	32	475	21 August 2024
How to split/join after discarding values General	5	2038	2 February 2021

Join specific array field in a string separated by blank space

Related topics