topic Re: How can we Add a space at end of string in Talend Studio

How can we Add a space at end of string

Anonymous — Thu, 21 Mar 2019 15:17:06 GMT

Hello All,

My requirement is to add a space at end of the string to every row in a column

My input

Pediatric Associates, LLP

and Expected output

Pediatric Associates, LLP

In above output space to be added at the end of the string

Can any have give an idea how to achieve my requirement?

Re: How can we Add a space at end of string

akumar2301 — Thu, 21 Mar 2019 15:42:09 GMT

String str = "abc;

str = str + " ";

Re: How can we Add a space at end of string

Anonymous — Thu, 21 Mar 2019 15:44:40 GMT

@uganesh thanks

Where can this be done , in tMap or tJavarow?

Re: How can we Add a space at end of string

akumar2301 — Thu, 21 Mar 2019 15:46:46 GMT

same thing ( Only on Last Column)

in tjavarow

output_row.str = input_row.str + " ";

in tMap

row1.str + " "

Re: How can we Add a space at end of string

Anonymous — Thu, 21 Mar 2019 16:12:02 GMT

thanks @uganesh it worked as per my requirement, Am doing camel casing for a strings, if the extension is CO

example before i had

Walgreens COunty CO

As it is checking for one space in and CO i wanted to add space at the end, and then changed code to find space CO space, now it worked exactly as per requirement.

Inially added space, later trimmed at the space at the end it worked fine

After this the result is

Walgreens County CO