topic Splitting a csv input column into several output columns in Talend Studio

Splitting a csv input column into several output columns

_AnonymousUser — Sat, 16 Nov 2024 14:14:20 GMT

Hi there,
I'm quite new to Jasper ETL so my question might be quite obvious, although I've not seen it discussed in the forum: I need to transform an input row using one of the columns of that row. This column is a semicolon-separated string. The output row should contain an additional column for each of the CSV fields.
I've tried to use tMap but could not find a "split" or "tokenize" function; also I was not able to figure out how to fill several fields from the result of such function, which would output a string array. I also tried a tJavaFlex component but could not get past a error message about the input schema being different than the internal schema of the component (which is precisely what I need to do...)
Does anyone here has a clue about how to do that ?
Thanks a lot,
Christian

Re: Splitting a csv input column into several output columns

Anonymous — Mon, 08 Sep 2008 15:30:09 GMT

Hi,

I thing you can use the component tExtractdelimitedFields to transforme on collumn of a schema in several. (category procccessing>fields)

That is the solution ?

best Regards

Jeremie

Re: Splitting a csv input column into several output columns

_AnonymousUser — Mon, 08 Sep 2008 16:59:29 GMT

Hi Jeremie,
thanks a lot for the quick answer. However I don't seem to have this particular component in the Palette currently, maybe because I'm using the free Jasper ETL version ?
Thanks,
Christian

Re: Splitting a csv input column into several output columns

Anonymous — Tue, 09 Sep 2008 01:01:34 GMT

tExtractDelimitedFields is under Palette -> Processing -> Fields

Re: Splitting a csv input column into several output columns

_AnonymousUser — Wed, 10 Sep 2008 14:53:37 GMT

I have no subdir under Palette -> Processing, only components (tAggregateRow, tAggregateSortedRow, etc...)
I'm using JasperETL v2.3.2
Are you using another, more feature-rich version of Talend ETL ?
Thanks,
Chris

Re: Splitting a csv input column into several output columns

Anonymous — Wed, 10 Sep 2008 19:58:31 GMT

which version of TOS are you using? because that component was available in TOS 2.4.0 (see attached pic)

And are you looking under the "Fields" folder under the "Processing" header?

Re: Splitting a csv input column into several output columns

Anonymous — Wed, 10 Sep 2008 22:30:19 GMT

I think the issue is that he's using Jasper and NOT "native" TOS.

Re: Splitting a csv input column into several output columns

Anonymous — Wed, 10 Sep 2008 22:38:54 GMT

tExtract*Fields were added in branch 2.4
JasperETL is exactly the same thing as Talend Open Studio, no removed feature, only "rebranding" (logos, icons and so on).

Re: Splitting a csv input column into several output columns

Anonymous — Thu, 11 Sep 2008 01:05:43 GMT

I submitted the forum's first question about the usage of tExtractDelimitedFields earlier today. If anyone has any documentation or description of how to use it, please let me know.
https://community.talend.com/t5/Design-and-Development/tExtractDelimitedFields/td-p/84317