Odoo data has 2 values seperating by the comma

Hello guys,

I have an issue with data pulled out of Odoo.
Some columns they have 2 values that separate by the comma. Any idea to change it to 1 value only?
Thanks in advance.

Data pulled out on N8N

Data input on Google Sheet

hi @semighoti

If you only need the first value you can use an expression to get only that value.
In the set node this would be easiest. Expression example for the first field: {{$json[“order_id”][0]}}

You can drag and drop the values as well :wink:

2 Likes

Save my day. It worked. Many thanks @BramKn

2 Likes

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