'Parse flat file in Mule 4 skipping header
How can we parse fixed length flat file skipping first few lines as header in Mule 4?
Input header:
HEADER
BOB 123 NEWYORK
TOM 456 DALLAS
I have tried using MIME type as application/flatfile
form: FIXEDWIDTH
id: 'record'
name: 'record'
values:
- { name: 'name', usage: M, type: String, length: 3 }
- { name: 'code', usage: M, type: String, length: 3 }
- { name: 'city', usage: M, type: String, length: 3 }
Solution 1:[1]
You need to add the header to the structure of the file.
Example:
form: FLATFILE
structures:
- id: 'file'
name: file
data:
- { idRef: 'header' }
- groupId: 'details'
count: '>1'
items:
- { idRef: 'record', count: '>1' }
segments:
- id: 'header'
name: "header"
values:
- { name: 'header', usage: M, type: String, length: 6 }
- id: 'record'
name: 'record'
values:
- { name: 'name', usage: M, type: String, length: 3 }
- { name: 'code', usage: M, type: String, length: 3 }
- { name: 'city', usage: M, type: String, length: 3 }
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | aled |
