• V
 

Split text into one message per line

Problem

You want to perform an operation on every line in a block text. For example, you want to add the line number to the beginning of each line.

Solution

The Split node can be used to split the message into one message per line. It can be followed by the nodes needed to operate on the individual lines of text, followed by a Join node to recombine them back into a single block of text.

Example

[{"id":"df6514f0.029748","type":"inject","z":"64133d39.bb0394","name":"inject","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":"","x":110,"y":900,"wires":[["11f53f61.2f7be1"]]},{"id":"11f53f61.2f7be1","type":"template","z":"64133d39.bb0394","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"one\ntwo\nthree\nfour\nfive","x":240,"y":900,"wires":[["760c1d71.c29744"]]},{"id":"760c1d71.c29744","type":"split","z":"64133d39.bb0394","name":"","splt":"\\n","x":190,"y":960,"wires":[["3e427aac.9b9596"]]},{"id":"3e427aac.9b9596","type":"change","z":"64133d39.bb0394","name":"Prepend line number","rules":[{"t":"set","p":"payload","pt":"msg","to":"(parts.index+1) & \": \" & payload","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":360,"y":960,"wires":[["d44d4767.945fd8"]]},{"id":"d44d4767.945fd8","type":"join","z":"64133d39.bb0394","name":"","mode":"auto","build":"string","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","timeout":"","count":"","x":530,"y":960,"wires":[["bfe3e43b.85fa88"]]},{"id":"bfe3e43b.85fa88","type":"debug","z":"64133d39.bb0394","name":"debug","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":650,"y":960,"wires":[]}]

Discussion

In the example, the Inject and Template nodes are used to inject a block of text with multiple lines.

one
two
three
four
five

The Split node’s default behaviour when passed a string is to split it into one message per line.

The Change node modifies each message payload using a JSONata expression: (parts.index+1) & ": " & payload - which uses msg.parts.index to get the line number and prepends it to the existing msg.payload.

Finally the Join node reassembles the messages into a single block of text:

1: one
2: two
3: three
4: four
5: five