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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

String handling with -

Hey Guys,

 

I have the string "4711" in tMap. I want to transform to "47-11". Is there such Java to transform like that?

 

Thanks for your participation,

 

Best Regards,

 

 

Labels (3)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

Hi,

Stricly based on your example, you can use the following:

StringHandling.LEFT(row6.Title1,2)+"-"+StringHandling.RIGHT(row6.Title1,2) 

View solution in original post

1 Reply
TRF
Champion II
Champion II

Hi,

Stricly based on your example, you can use the following:

StringHandling.LEFT(row6.Title1,2)+"-"+StringHandling.RIGHT(row6.Title1,2)