using an API call I receive an memoText field, which contains the following data (among others):
----
Locatie op de terminal
- Kade thv loods 12
Shift
- Avond
Dienst
- Ploeg B
Afdeling
- Hout, staal & metaal
Soort incident
- Bijna ongeval
Geconstateerd door? (overslaan bij ongeval met letsel)
- Niemand
-----
I want to extract the data from this field using tExtractRegexFields.
When I want to retrieve the data from 'Locatie op de terminal' I can use regex Locatie op de terminal\n.* and it will retrieve both the lines which is good. But I allso want to retrieve the lines for Shift, using Shift\n.* for regex.
How to I get both values mapped to two different output colums of the tExtractRegexFields component ?? So that outputColumn1 has the value of 'Locatie op de terminal
- Kade thv loods 12' and outputColumn2 has the value of 'Shift - Avond' and so on.
What will happen if one of the values doesn't not exist within the memotext field ? can it still be parsed ?
Find a online regext tester such as https://regexr.com/, learn and test your regex. If the value does not exist, the column will has a null value output.
What I miss is how the ExtractRegexFields component works.
I got it working using the regular expressions, but for every field the component returns one row.
So using this expression :
"(Locatie op de terminal\\s*\n.*)|(Shift\\s*\n.*)|(Afdeling\\s*\n. *)"
Results in three rows and not one row with three fields filled with the values
But reading the documentation of Talend ExtractRegexFields and seeing the example, it suggests that it delivers one row with the fields. But not in my case.
@Jacco de Zwart, tExtractRegexFields output one row with three fields with the values, if you want to split the values to be multiple rows, use tNormalize component after tExtractRegexFields, please read the component documentation and learn this component, let me know if you have any questions.
