topic Re: How to combine/concatenate 3 string fields and create a new field in Talend Studio

How to combine/concatenate 3 string fields and create a new field

Bharath12 — Sat, 16 Nov 2024 06:26:27 GMT

Hi All,

I am new to Talend and I have requirement to create a new field in output easticsearch database.

My input has first name, lastname and middlename which are of string type.

And I want to concatenate these 3 fields and generate a new field in

output easticsearch database.

I want to get output like "fullname" : { "given" : "<source.firstname>", "middle" : "<source.middle>", "family" : "<source.lastname>" }

can some one help me how to do that in TMAP

thanks in advance.

Anonymous — Mon, 04 Mar 2019 19:04:23 GMT

Hello

(row5.FirstName + " " +row5.MiddleName + " "+row5.LastName) .replaceAll("null","")

This is the bettter way to concatinate, Please give kudos and accept solution if it works

akumar2301 — Mon, 04 Mar 2019 22:03:56 GMT

if you need output string with double quotes

"\"fullname\" : {\"given\" : \""

+ row1.firstname +

"\", \"middle\" : \""

+ row1.middle +

"\", \"family\" : \""

+ row1.lastname +

"\" }"

Anonymous — Tue, 05 Mar 2019 17:43:54 GMT

Thank you @rchinta