topic Re: tJavaRow to split string in Talend Studio

tJavaRow to split string

rp2018 — Fri, 15 Nov 2024 23:27:56 GMT

I have a following string which I need to split based on 2 delimiters. Will be using tJavaRow to split this.

["Test Company, Inc.","Test Company (Test) LLC","VM (Test), LLC","JK (Test), LLC"]

Need result such as:

Test Company, Inc.

Test Company (Test) LLC

VM (Test), LLC

JK (Test), LLC

Re: tJavaRow to split string

Anonymous — Wed, 01 Dec 2021 03:09:33 GMT

First, remove the square brackets "[","]" from the string on a tJavaRow.

Then, use tNormalize to normlize the line to multiple rows using item seperator "\","

Finally, remove the double quotes from each value on a tJavaRow2.

output_row.line = input_row.line.replaceAll("\"","");

Result:

Starting job testing at 11:06 01/12/2021.

[statistics] connecting to socket on port 3346

[statistics] connected

Test Company, Inc.

Test Company (Test) LLC

VM (Test), LLC

JK (Test), LLC

[statistics] disconnected

Job testing ended at 11:06 01/12/2021. [Exit code = 0]

Regards

Shong

Re: tJavaRow to split string

rp2018 — Wed, 01 Dec 2021 05:06:46 GMT

Thanks Shong for the above solution.

I have another column which contains a picklist id which needs to be associated to this. I've tried adjusting your code to get the result,

but no success.

|Value |Label

|=------------------------------------------------------------------------------------------+----

|[1000,1002,2200,3400]|["Test Company, Inc.","Test Company (Test) LLC","VM (Test), LLC","JK (Test), LLC"]

-------------------------------------------------------------------------------------------+-----

Need result such as this in 2 separate columns:

Value Label

1000 Test Company, Inc.

1002 Test Company (Test) LLC

2200 VM (Test), LLC

3400 JK (Test), LLC

Re: tJavaRow to split string

Anonymous — Wed, 01 Dec 2021 06:19:47 GMT

Process separately Value and Label using the way I provided in my previous post.

Next, add a sequence id to each row, eg:

Numberic.sequence("value",1,1)

Finally, do an inner join based on sequence id to merge two columns Value and Label.

Regards

Shong

Re: tJavaRow to split string

rp2018 — Mon, 13 Dec 2021 21:01:40 GMT

Shong, your recommendation worked with little twick of using tReplace component.

For others reference, this is how I've designed the job.

Input file: