Field Parser helps extract desired values from Email. Create a field parser for each data point to be extracted. Following are types of Field Parsers
- Text – used to extract data attributes using text based start and end bounds
- Regex Selector – extract data attributes by using regular expressions
- Path – use XPath (most suited to be used for XML content of HTMLBody as source) for data attribute extraction
- Fixed – specify fixed/static value as field parser value
- Full Value – extract full value of given Email attribute (Example: use to get full value of From address)
Create a new Field Parser
- Let’s move on to the Field Parsers section.
- Click on ‘New‘ to create a new Field Parser.
- Enter the ‘Reference Name’ as ‘getEmail’ and then select Type as ‘Text’.
- Afterwards select Source as ‘Text Body’ and click on ‘Save’ button.
- Click on the created Field Parser to open the record layout.
- Click on the ‘Build’ button on the top right corner.
- When user selects Source as a ‘Text Body’ by selecting this ‘Max Source Line’ field will come automatically and fill its value as ‘3’.
- Afterwards in ‘Field Parser Config’ set ‘Start Range’ as ‘Any of Characters’ and put ‘COMA’ in it and set ‘End Range’ as ‘BlankSpace.
- Choose the correct option from the ‘Multiple Results Configurations‘.
- Write a sample text in the Text Area and click on ‘Test‘ to check the functionality. click on ‘Save‘.
| -Set Reference Name We can use ‘Reference Name’ within the Field Parser when we create a new parser and ‘Reference Name of field is to be used for mapping’. |
Example: Extract Field parser as Text
Let’s move on to the Field Parsers section.
- Click on ‘New‘ to create a new Field Parser.
- Enter the ‘Reference Name’ as ‘company_Name and then select Type as ‘Text’.
- Afterwards select Source as ‘Text Body’ and click on ‘Save’ button.
- Click on the created Field Parser to open the record layout.
- Click on the ‘Build’ button on the top right corner.
- When user selects Source as a ‘Text Body’.
- Afterwards in ‘Field Parser Config’ set ‘Start Range’ as ‘Any of Characters’ and put ‘,’ in it and set ‘End Range’ as ‘Any of Characters’ and put ‘.’ In it.
- Choose the option from the ‘Multiple Results Configurations‘ and select its value as ‘Last’.
- Write a sample text in the Text Area and click on ‘Test‘ to check the functionality.
- click on ‘Save‘.
Example: Extract Field parser as Date
Let’s move on to the Field Parsers section.
- Click on ‘New‘ to create a new Field Parser.
- Then Select Output Type as ‘Date’ and enter the ‘Reference Name’ as ‘company_Name.
- Select Type as ‘Regex Selector’ afterwards select Source as ‘Text Body’ and click on ‘Save’ button.
- Click on the created Field Parser to open the record layout.
- Click on the ‘Build’ button on the top right corner. When user selects Source as a ‘Text Body’.
- Afterwards Put the Regex in the Value field ‘\d\d\d\d-(0?[1-9]|1[0-2])-(0?[1-9]|[12][0-9]|3[01])+’ .
- Choose the correct option from the ‘Multiple Results Configurations‘ and select its value as ‘First’.
- Write a sample text in the Text Area and click on ‘Test‘ to check the functionality.
- Click on ‘Save‘.
Example: Extract Field parser as Number
Let’s move on to the Field Parsers section.
- Click on ‘New‘ to create a new Field Parser.
- Then Select Output Type as ‘Number’ and enter the reference name as ‘phone_Number and then select Type as ‘Regex Selector’.
- Afterwards select Source as ‘Text Body’ and click on ‘Save’ button.
- Click on the created Field Parser to open the record layout.
- Click on the ‘Build’ button on the top right corner.
- When user selects Source as a ‘Text Body’.
- Afterwards Put the ‘Regex Selector’ in the Type field and provide Value ‘[0-9]’.
- Choose the correct option from the ‘Multiple Results Configurations‘ and select its value as ‘First’.
- Write a sample text in the Text Area and click on ‘Test‘ to check the functionality.
- Click on ‘Save‘.
Example: Extract Field parser as Currency
Let’s move on to the Field Parsers section.
- Click on ‘New‘ to create a new Field Parser then Select Output Type as ‘Currency’ and enter the reference name as ‘revenue_Amount.
- Then select Type as ‘Regex Selector’ afterwards select Source as ‘Text Body’.
- Click on ‘Save’ button.
- Click on the created Field Parser to open the record layout.
- Click on the ‘Build’ button on the top right corner.
- When user selects Source as a ‘Text Body’.
- Afterwards Put the ‘Text’ in the Type field and in ‘Field Parser Config’ set ‘Start Range’ as ‘Text Delimiter’ and put ‘rs.’ in it and set ‘End Range’ as ‘BlankSpace’.
- Choose the correct option from the ‘Multiple Results Configurations‘ and select its value as ‘First’.
- Write a sample text in the Text Area and click on ‘Test‘ to check the functionality. click on ‘Save‘.
