Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
roee1983
Contributor III
Contributor III

Text Between Function

Hi all,

i need your help with the next issue :

i need to get the number between the third and the fourth      "_"  ( 555)

for example :

aaaa_ddd_222_555_jacac

somtimes it can be 3 chars and somtimes even 5 or 6 .

Thanks

Roee

1 Solution

Accepted Solutions
el_aprendiz111
Specialist
Specialist

Hi,

=SubField('aaaa_ddd_222_555_jacac','_',-2)

View solution in original post

1 Reply
el_aprendiz111
Specialist
Specialist

Hi,

=SubField('aaaa_ddd_222_555_jacac','_',-2)