Split field seperated by pipe delimeter

Questions
1

I have a field which is derived from a http get request, one of the fields in the json response is called myKeys, this field contains two strings separated by a pipe delimiter, example 9997|6555

what can i use to split these out whilst ultimately combining all the other fields unmodified?

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

hello @thedom4301
you can use the Edit Fields Node to split the string with something like {{$json.myKeys.split('|')}}

2 Likes
4

Thanks that worked a treat

5

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