Logilab ELN - Parser Setup

Parsing is interpreting/compiling that breaks data into its structured elements for easy translation. The files that are uploaded to the computer are split into parts; data is extracted and imported into the computer.

Once Sample Split is done, you can set up parser. To do so, follow these steps:

1. In the Method master screen, select a method, click Methodand then click Parser Setup as shown in the figure:

FIGURE: Parser Setup

1. The Parser Setupscreen appears as shown in the figure:

FIGURE: Parser Setup Screen

Controls and their use in the Parser Setup screen:

Select to extract the data. Select the data you want to parse and then clickto extract the data.

Mark beginning of the data block.

Mark end of the data block

Mark column end of the data block

Click to save the field marked.

Method Name – Click to view list of fields added. You can view, edit or delete the fields.

Click to clear the parser marking and reset and refresh the screen.

Click to open Store Field Techniques screen where you can merge/split/shift fields with the selected delimiter.

Click to save the fields in the database table.

1.1.1 Mark Required Data

In the Parser Setup screen, you can mark required data and map it to a field name. You can also mark beginning and end data blocks to precisely identify the required data block.

To mark required data, follow these steps:

1. Select required data.

Note:   Always select required data until the end mark.

2. In the Type field namefield, type field name for the selected data and then click;as shown in the figure:

FIGURE: Parser Setup – Marking required Data Block

The required data is highlighted in green as shown in the figure:

FIGURE: Parser Setup –Required Data Block Marked

1.1.2 Mark beginning of the data block.

Once you mark required data, you need to mark beginning of the data block. You can mark the beginning of the data block either on the left side of the data block or on top of the data block whichever is available. In this example, we do not have data at the left-side, but we do have data at the top. So we can mark the beginning of the data block at the top.

1. To mark beginning of the data block, select the data and then click as shown in the figure:

FIGURE: Parser Setup – Marking Beginning of the Data Block

1.1.3 Mark end of the data block

Once you mark the beginning of the data block, you need to mark the end of the data block. You can mark the end of the data block either on the right-side of the data block or on bottom of the data block whichever is available. In this example, we do not have data at the right-side, but we do have data at the bottom of the required data. So we can mark the end of the data block at the bottom.

2. To mark end of the data block, select the data and then clickas shown in the figure:

FIGURE: Parser Setup – Marking End of the Data Block

1.1.4 Identify the Column End of the data Block.

3. To mark the column end of the data block select double arrowthat appears next to the required data block and then click as shown in the figure:

FIGURE: Parser Setup – Marking Column End of the Data Block

The marked column end appears in yellow as shown in the figure:

FIGURE: Parser Setup – Marked Column End of the Data Block

3. Click to save the field marked.
4. Same way, identify and mark required data blocks / fields.

Even if you don’t type a field name for the selected data block, the parser will save the data block with default field name as Field 1, Field 2 etc.

1.1.5 Multi Field Parsing

To parse multi field values, follow these steps:

1. Select a block of values with multiple rows and columns. Mark beginning, end and end of column as shown in the figure:

5. Click to preview the fields. The screen appears as shown in the figure:

FIGURE: Store Field Technique Screen

6. In the screen, you can see the marked fields in the previous screen appear in a single column. This screen allows you to merge/split/shift data using the selected delimiter.

1.1.5.1 Split Fields

To split the columns, follow these steps:

FIGURE: Splitting Columns

1.1.5.2 Merge Fields

Once you select two columns to merge, click to merge the columns. And then click to view the result as shown in the figure:

FIGURE: Merging Fields

1.1.6 Viewing, Editing and Deleting Marked Fields

1. Click the method name to view list of fields added as shown in the figure:

FIGURE: Viewing, Editing and Deleting Marked Fields

7. Click to view the data block/field marked.
8. Click to edit the field name. The field name appears in the Field Key box for editing. You can also change the data type of the field if required, click Update and then on the Parser Setup screen click Submit.
9. Click to delete the field.

1.1.7 Submitting Parser Setup to Store in the Table

1. Click Submit. The fields are stored in the table, and you will see a success message as shown in the figure

FIGURE: Parser Field Appears as “1” after Parser Setup Done

In the Method Master screen, the Parser Status field of the method appears as “Done” after you setup fields for parsing.

1.1.8 Evaluate Parser

Once you mark fields for parsing, you can evaluate the fields. To do so, follow these steps:

1. In the Method Master screen, select the method, click Methodand then click Evaluate Parser as shown in the figure:

FIGURE: Evaluate Parser Option

The Evaluate Parser screen appears as shown in the figure:

FIGURE: Evaluate Parser Screen Showing Fields and Values

You can see the list of fields added in the Parser Setup screen and values for the fields captured appear as shown in the above figure.

1.1.9 Copy Method

The Copy Method option enables you to copy a method after sample split and parser setup are done. You can copy a method for the same instrument category. So, while copying a method you need to specify the instrument name. Instruments from the same instrument category of the method you copy will appear in the Instruments field. Once copied, you can make required changes to the copied method for further use.

1. In the Method Master screen, select the method to copy, click Methodand then click Copy Method as shown in the figure:

FIGURE: Copy Method Option

The Copy Method screen appears as shown in the figure:

FIGURE: Copy Method

10. In the Instruments field, select the instrument. Instruments from the instruments category of the method you want to copy will appear.
11. In the method name field, name for the new method will appear.
12. Click Submit. Copy of the method with new method name will be created.