 |
 | Create a File regex metadata
|
In the Repository on the left of the Talend Open Studio main screen: Expand the Metadata node. Right-click on File regex. In the menu, click Create file regex to open the New RegEx File wizard.
|
 |
In the New RegEx File wizard: In the Name field, name the metadata regex. Click Next to continue.
|
 |
Click Browse... and select the regex.txt file from the wizard. From the Format list, select your computer OS. Click Next. |
 |
In the Regular Expression settings area, set the regular expression based on the regex file schema: "^firstname=(.+?)lastname=(.+?)age=(\\d+)$". In the Limit Of Rows area, check the box and fill in the number of rows to be processed: 3. Click Refresh Preview to take the new parameters into account. Click Next.
|
 |
In the Description of the Schema area, modify the default schema. Check the Key case next to column0. Select column2 and click [x] to delete the column. Click Finish.
|
 |
In the Repository on the left: The regex metadata is displayed in the Metadata > File regex node.
|
