Splitting Text from Webhook

Hello, I have a webhook that sends its data in batches (Waalaxy)…The information comes in seperated with a colon…In Zapier, I’d use transform and split them…how do you do this in n8n?

Thanks in advance

Hey @John_Parker,

Welcome to the community :tada:

You could use a function node to tweak the tweak data but there could be a better way, Any chance you send the body data over from the webhook node?

1 Like

“headers”: {
“host”: “n8n.mloboss.com”,
“user-agent”: “axios/0.25.0”,
“content-length”: “1073”,
“accept”: “application/json, text/plain, /”,
“content-type”: “application/json”,
“x-forwarded-for”: “”,
“x-forwarded-host”: “n8n.mloboss.com”,
“x-forwarded-port”: “443”,
“x-forwarded-proto”: “https”,
“x-forwarded-server”: “2043bc11c811”,
“x-real-ip”: “”,
“accept-encoding”: “gzip”
“params”: {},
“query”: {},
“body”: {
“_id”: “62fd1788045d7da4cdc19813”,
“firstName”: “John;Maria;Bruce”,
“lastName”: “Doe;Phenix;Mclean”,
“occupation”: “Sales manager at Netflix;UI designer at Meta;Ex software engineer at Google, i’m looking for a new job !”,
“location”: “Paris;New York City;London”,
“email”: “[email protected];;”,
“dropcontactEmail”: “;;”,
“phoneNumbers”: “mobile: 0787123476 - fixe: 0389076542;;”,
“prospectList”: “My prospect list;Peoples at Meta;Job Seekers”,
“linkedinUrl”: “https://linkedin.com/in/johndoe;https://linkedin.com/in/mariaphenix;https://linkedin.com/in/brucemclean”,
“salesNavigatorUrl”: “;;”,
“premium”: “No;Yes;No”,
“jobSeeker”: “No;No;Yes”,
“profileStatus”: “connected;pending;not_connected”,
“messageSent”: “Yes;No;No”,
“messageReplied”: “Yes;No;No”,
“emailSent”: “Yes;Yes;No”,
“emailReplied”: “Yes;Yes;No”,
“connectedAt”: “Thu Dec 23 2021 16:01:10 GMT+0100;;”,
“firstMessageAt”: “Thu Dec 25 2021 09:30:46 GMT+0100;;”,
“tags”: “Custom Tag;Meta People;”,
“company_name”: “Netflix;Meta;”,
“company_linkedinUrl”: “;https://www.linkedin.com/company/meta/;”,
“company_website”: “;https://about.facebook.com/fr/meta/;