topic Re: tRegexField to split a column in Talend Studio

tRegexField to split a column

Anonymous — Mon, 13 Jan 2020 10:57:03 GMT

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)

Re: tRegexField to split a column

fdenis — Tue, 14 Jan 2020 09:16:22 GMT

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

Re: tRegexField to split a column

Anonymous — Tue, 14 Jan 2020 10:13:09 GMT

Thank you for the answer.

Re: tRegexField to split a column

Anonymous — Tue, 14 Jan 2020 10:34:31 GMT

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

Re: tRegexField to split a column

fdenis — Tue, 14 Jan 2020 15:06:22 GMT

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.

Re: tRegexField to split a column

Anonymous — Tue, 14 Jan 2020 15:15:15 GMT

oh sorry my bad on this . Its name is tExtractRegexFields