tRegexField to split a column

[Anonymous]

Hi guys, 

I'm trying to split a column into severals.

First step, I would like to retrieve any chacarter before the first , 

so I used this regular expression : "([^,]+?),.*"

It work on a website editor like Rubular but doesn"t work on the component and the tLogRow displays blank lines.

Can you explain me the reason please ?

Exemple : My name is David(a), I am england

The result should be My name is David(a)

[fdenis · Accepted solution]

your regexp may be "([^,]*),.*"
but you may uses split for that.

tRegexField is not know as a talend component,
you may use tMap or tjavarow to apply regexp.

Regrards

[Anonymous]

Thank you for the answer. 

[Anonymous]

why did you say  tRegexField is not a Talend component ? I found it well in the Palette

[fdenis]

because you cannot find this component into talend doc.
https://help.talend.com/search/all?content-lang=en-US
it may be an addon or a custom component.

[Anonymous]

oh sorry my bad on this . Its name is tExtractRegexFields