sub field() help

[mahitham]

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

[SukumarBera · Accepted solution]

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

Regards,
Sukumar Bera

[SukumarBera]

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

[arulsettu]

Maybe like this

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