Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

sub field() help

Hi,

Can any one please help me on below issue.

I have a Name Field like below, from the Name field please help me to get the Expected Name output field

Name

Wholesale Market [ 239801]

Risk Control Server [ 1234567]

Expected Name output

Wholesale Market

Risk Control Server

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: sub field() help

Hi Mahitham,
Please use PurgeChar(Name,'0123456789[]')

Regards,
Sukumar Bera

View solution in original post

3 Replies
Highlighted
Contributor III
Contributor III

Re: sub field() help

Hi Mahitham,
Please use PurgeChar(Name,'0123456789[]')

Regards,
Sukumar Bera

View solution in original post

Highlighted
Contributor III
Contributor III

Re: sub field() help

Another way to use LEFT() with INDEX() string functions. See below. Minus 2 is to eliminate the "WHITE SPACE"

& "[" characters.

 

left(Name,Index(Name,'[')-2)

 

Regards,

Sukumar Bera

Highlighted
Master III
Master III

Re: sub field() help

Maybe like this

 

SubField('Risk Control Server [ 1234567]','[',1)