Hi, I am looking to impement a File listener which will read a fixed length flat file. Each line has data but we need to derive the fields based on the positions and there is no delimiter. Looking to see how we can use Parse Structured/ Map Strcutured rules to achieve the requirement.
Thanks for all the help in advance!
File Listener Parse/Map structured
13 days later
Hi seanpega,
Fixed length file processing are quite challenging to handle because of its sensitive data structure. But then with proper design, we'll still be able to crack it. Just see if you can follow the below steps,
- Analyze the final version of your fixed length file E2E and make a not of each attribute and its length in a notepad
- Start configuring structured parse rule to parse the incoming data in the file.
- Use below shown method to parse the attribute from the specific offset and map it to a clipboard property
You can also maintain a data type to configure the length of each field and pass it as a parameter to the activity. With this, if there is a change in the file length, you can directly update the data type and the changes will be minimal.