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

[Bharath12]

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 · Accepted solution]

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]

if you need output string with double quotes

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

+ row1.firstname +

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

+  row1.middle +

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

+ row1.lastname +

"\" }"

[Anonymous]

Thank you @rchinta