Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can we Add a space at end of string

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?

Labels (2)
1 Solution

Accepted Solutions
akumar2301
Specialist II
Specialist II

same thing ( Only on Last Column)

 

in tjavarow 

 

output_row.str = input_row.str + " ";

 

in tMap 

 

row1.str + " "

View solution in original post

4 Replies
akumar2301
Specialist II
Specialist II

String str = "abc;

 

str = str + " ";

Anonymous
Not applicable
Author

@uganesh thanks 

Where can this be done , in tMap or tJavarow?

akumar2301
Specialist II
Specialist II

same thing ( Only on Last Column)

 

in tjavarow 

 

output_row.str = input_row.str + " ";

 

in tMap 

 

row1.str + " "

Anonymous
Not applicable
Author

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