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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Text between function help

Hi,

Can any one please help me to get the below output from the input field

Input:

Indian Core Banking HSBC [INDIA] [238148]

Indian Core Banking Ireland [28879]

Output:

238148

28879

Thanks in advance

 

1 Reply
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

try with

Purgechar(Subfield(Field,' ',-1),'[]')