{"id":6752,"date":"2019-01-24T23:50:31","date_gmt":"2019-01-25T04:50:31","guid":{"rendered":"https:\/\/www.jitendrazaa.com\/blog\/?p=6752"},"modified":"2019-01-24T23:50:40","modified_gmt":"2019-01-25T04:50:40","slug":"defining-pipe-delimited-separator-in-mulesoft-3-4","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/defining-pipe-delimited-separator-in-mulesoft-3-4\/","title":{"rendered":"Defining pipe delimited separator in Mulesoft 3 & 4"},"content":{"rendered":"\n

Mulesoft 3<\/h2>\n\n\n\n

As discussed in previous post, to use pipe operator as separator. Navigate to Reader\u00a0Configuration<\/strong> of Transformation message component<\/p>\n\n\n\n

\"Reader
Reader Configuration in Transform Message – Mulesoft 3<\/figcaption><\/figure>\n\n\n\n\n\n\n\n

and provide required value in separator , In our case, its pipe operator<\/p>\n\n\n\n

\"Mulesoft
Mulesoft 3 – Transform Message Reader Configuration<\/figcaption><\/figure>\n\n\n\n

Mulesoft 4<\/h2>\n\n\n\n

To use Pipe separator in Mulesoft 4, we need to configure it in File\u00a0Read<\/strong> component, instead of Transformation message component unlike Mulesoft 3<\/p>\n\n\n\n

\"Mulesoft
Mulesoft 4 – Pipe Delimited Separator<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

How to use Pipe delimiter as separator in Mulesoft 3 and 4<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[454],"tags":[120,455,457],"class_list":["post-6752","post","type-post","status-publish","format-standard","hentry","category-mulesoft","tag-integration","tag-mulesoft-3","tag-mulesoft-4"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":6739,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/process-pipe-delimited-file-in-mulesoft-3\/","url_meta":{"origin":6752,"position":0},"title":"Use pipe delimited file to upsert record in Mulesoft 3","author":"Jitendra","date":"January 24, 2019","format":false,"excerpt":"Use Mulesoft to upsert record in Salesforce using Pipe delimited file","rel":"","context":"In "Integration"","block_context":{"text":"Integration","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/"},"img":{"alt_text":"Upsert record in Salesforce using Mulesoft","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/01\/Upsert-record-in-Salesforce-using-Mulesoft.png?fit=500%2C215&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":6863,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/mulesoft-live-demo-alpharetta-developer-group-meet\/","url_meta":{"origin":6752,"position":1},"title":"Introduction to Mulesoft with Example – Alpharetta Developer Group Meet","author":"Jitendra","date":"June 17, 2019","format":false,"excerpt":"Slides and Video from Alpharetta Developer group meet - Loading data in Salesforce using Mulesoft 4","rel":"","context":"In "Mulesoft"","block_context":{"text":"Mulesoft","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/mulesoft\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/sqWLC2I8Ozg\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":30699,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/complete-mulesoft-guide-40-expert-interview-questions\/","url_meta":{"origin":6752,"position":2},"title":"Complete MuleSoft Guide: 40+ Expert Interview Questions & Answers","author":"Jitendra Zaa","date":"December 18, 2025","format":false,"excerpt":"Master MuleSoft interviews with 40+ expert questions covering API-led connectivity, DataWeave, Kafka, Salesforce integration, AI capabilities (Agentforce, MAC Project), CloudHub deployment, VPC\/VPN security, certifications, and career paths. Includes Gartner iPaaS 2025 insights.","rel":"","context":"In "Integration"","block_context":{"text":"Integration","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/"},"img":{"alt_text":"Complete MuleSoft Guide - 40+ Expert Interview Questions covering API-Led Connectivity, DataWeave, Agentforce AI, CloudHub VPC, Certifications, Career Path, Kafka Integration, and Gartner iPaaS 2025","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2025\/12\/mulesoft-interview-questions-2025-featured-new.png?fit=1200%2C704&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":6898,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/mulesoft-4-transformation-convert-json-to-xml\/","url_meta":{"origin":6752,"position":3},"title":"Mulesoft 4 Transformation – Convert JSON to XML","author":"Jitendra","date":"September 15, 2019","format":false,"excerpt":"Dataweave code to convert JSON to XML in Mulesoft 4","rel":"","context":"In "Mulesoft"","block_context":{"text":"Mulesoft","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/mulesoft\/"},"img":{"alt_text":"Mulesoft-Project-Convert-JSON-to-XML","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2019\/09\/Mulesoft-Project-Convert-JSON-to-XML.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":7741,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/salesforce-bulk-api-2-using-mulesoft\/","url_meta":{"origin":6752,"position":4},"title":"Salesforce Bulk API 2 using Mulesoft","author":"Jitendra","date":"November 20, 2022","format":false,"excerpt":"Demo of using Bulk API 2 & Solving most common errors","rel":"","context":"In "Mulesoft"","block_context":{"text":"Mulesoft","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/mulesoft\/"},"img":{"alt_text":"Bulk API 2 using MuleSoft","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Bulk-API-2-using-Mulesoft.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7731,"url":"https:\/\/www.jitendrazaa.com\/blog\/integration\/mulesoft\/working-with-postgresql-on-mac-locally\/","url_meta":{"origin":6752,"position":5},"title":"Working with PostgreSQL on Mac locally","author":"Jitendra","date":"November 16, 2022","format":false,"excerpt":"This post walkthrough installing PostgreSQL, PGAdmin, starting & stopping service as need and Mulesoft tips","rel":"","context":"In "Mulesoft"","block_context":{"text":"Mulesoft","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/integration\/mulesoft\/"},"img":{"alt_text":"Working with PostgreSQL on Mac locally","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Working-with-PostgreSQL-on-Mac-locally.png?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Working-with-PostgreSQL-on-Mac-locally.png?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Working-with-PostgreSQL-on-Mac-locally.png?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2022\/11\/Working-with-PostgreSQL-on-Mac-locally.png?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=6752"}],"version-history":[{"count":1,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6752\/revisions"}],"predecessor-version":[{"id":6754,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/6752\/revisions\/6754"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=6752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=6752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=6752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}