topic Re: How to add prefix and suffix? in Talend Studio

How to add prefix and suffix?

Anonymous — Thu, 13 Feb 2014 09:52:53 GMT

Suppose I have data as follows,
Emp_name|Emp_Id|Emp_dept
Leonardo DiCaprio|1000|Finance
Cristian Bale|1004|Security
Jennifer Lawrence|1002|HR
Morgan Freeman|1006|Admin
Now say I want to add, prefix 'Dr. ' to every entry under column name Emp_name. For example, data in output should be something as follows,
Dr. Leonardo DiCaprio|1000|Finance
Dr. Cristian Bale|1004|Security
Dr. Jennifer Lawrence|1002|HR
Dr. Morgan Freeman|1006|Admin
Or maybe I want to add, suffix 'ABC' to every entry under column name Emp_Id. For example, data in output should be something as follows,
Leonardo DiCaprio|1000ABC|Finance
Cristian Bale|1004ABC|Security
Jennifer Lawrence|1002ABC|HR
Morgan Freeman|1006ABC|Admin

Re: How to add prefix and suffix?

Anonymous — Thu, 13 Feb 2014 10:09:59 GMT

Hi,
tMap component can meet your needs.
Best regards
Sabrina

Re: How to add prefix and suffix?

Anonymous — Thu, 13 Feb 2014 11:47:42 GMT

Hi, Xdshi.. thanks for your help... it works. What I wanted to know is that you have marked the data type section to show that this logic works on string only... right? Or you want to show that data types on both sides should be matching.

Re: How to add prefix and suffix?

Anonymous — Mon, 17 Feb 2014 07:16:56 GMT

Hi,
The "String" type can add string(prefix and suffix tring s=string1+string2) directly with "+". This logic works on string only.
Best regards
Sabrina