Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-02-28 12:11 PM

Strip 6 numbers out of a string (EASY POINTS!)

Please strip the 6 digit number that starts with a '6' out of this alphanumeric string:

KL20000000621103EDLBR

So i only need 621103. Please help and points will be awarded fast. Thanks!

565 Views
0 Likes
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎2018-02-28 12:14 PM

May be this

=Mid('KL20000000621103EDLBR', Index('KL20000000621103EDLBR', '6'), 6)

View solution in original post

535 Views
0 Likes
2 Replies
sunny_talwar
MVP
MVP
‎2018-02-28 12:14 PM

May be this

=Mid('KL20000000621103EDLBR', Index('KL20000000621103EDLBR', '6'), 6)

536 Views
0 Likes
Anonymous
Not applicable
‎2018-02-28 12:17 PM
Author

In response to sunny_talwar

thats super hawt, thanks

535 Views
0 Likes