Fixed Length Parser¶
Fixed Length Parser processes a stream of fixed length data as an input and give elements as parsed output. This is useful when the source data is in text format (information is contained in a single field) and it needs to be put into multiple fields for further integration.
In this document, we will learn how you can use Fixed Length Parser in Astera Centerprise.
The sample data that we are using is a fixed length text file containing customers’ information.
Observe that all the information such as name, street number, street type, city, state and zip code are concatenated in a single field. Now we want to parse the Contact_Details field into Name, Street Number, Street Type and other respective fields.
To parse the data into separate fields, we will use Fixed Length Parser object in Centerprise.
To parse the data, we first have to extract it. Since the data is stored in a continuous stream, can not extract it directly using a Fixed Length File Source object. Therefore, we will use a combination of transformations to get the desired outcome. The diagram below explains the process that we’ll be following, right from extraction to to parsing the data.
Let’s begin with extracting the data.
1. Go to Toolbox > Transformations > Constant Value and drag-and-drop the Constant Value object onto the designer.
2. Right-click on the object’s header and select Properties from the context-menu.
3. In the Constant Value section, provide the file path of the source file (file containing customers data in a stream). Click OK.
4. Next, go to Toolbox > Function Transformations > Files > ReadFileText(String filePath) - String and drag-and-drop the object onto the designer.
You an see that the dragged transformation object has two sub-nodes - Input and Output.
5. Expand the Input node and map the Value field from the Constant Value Transformation object to the filePath field inside the Read File Text object.
This will redirect Centerprise to read the data from the given file path. Now we can use the Fixed Length Parser object to parse the text data into separate fields.
Using Fixed Length Parser¶
1. To get the Fixed Length Parser object, go to Toolbox > Text Processors > Fixed Length Parser and drag-and-drop the object onto the designer. Map the Value field, under the Read File Text object, onto the Text field inside the Fixed Length Parser object.
You can see that the dragged-object also contains an Output sub-node which is currently empty.
2. Configure the Fixed Length Parser object by right-clicking on its header and going to Properties.
3. A properties window will open. Here you will see three options, make sure to check the first two options.
4. Click Next and you will be directed to a Source Fields window.
Here, you have to provide the name of each field that you want to parse the source date into, as shown below.
5. Click OK. Now expand the Output node inside Fixed Length Parser object, you will see all the fields that you have created in the previous step.
6. Right-click on the object’s header and select Preview Output from the context menu.
A Data Preview window opens up. Expand the node and you will see a parsed output of each record.
To store this parsed output, write it to a destination file.
Writing to a Destination¶
1. Right-click on the Output sub-node inside the Fixed Length Parser object, go to Write to > Excel Workbook Destination. An Excel Workbook Destination object is added to the dataflow designer with auto-mapped fields.
2. Configure settings for Excel Workbook Destination object.
Learn how to configure settings for Excel Workbook Destination from here.
3. Click on the Start Dataflow button placed in the toolbar at the top to create this destination file.