Odoo data has 2 values seperating by the comma

[semighoti]

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

[BramKn]

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

[semighoti]

Save my day. It worked. Many thanks @BramKn