Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
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

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

Regards,
Sukumar Bera

View solution in original post

3 Replies
Highlighted
Contributor III
Contributor III

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

Regards,
Sukumar Bera

View solution in original post

Highlighted
Contributor III
Contributor III

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

Maybe like this

 

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