Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

want to add '-' to count the 6th data from the left.

I have a field 'Lot '

in field  'Lot ' contains data :

Sxbbb_0-1679643486797.png

 

want to add '-' to count the 6th data from the left.

EX

165052171

A0172050012

     

 

3 Replies
MarcoWedel

Where is the '-' sign in this example?

MarcoWedel_0-1679668160869.png

 

Sxbbb
Creator III
Creator III
Author

EX

165052-171

A0172050-012

MarcoWedel

How does  '-' "count the 6th data from the left" in these examples?