exclude first word from column

[#1]

Hi,

I have strings like below in a column.

2AD Postpaid

2ED Prepaid

2MD Wireless

how can i exclude the first letter while loading the data.

thanks

Prasanta

[Chanty4u]

try this

keepchar([

FieldName],'abcdefghijklmnopqrstuvwxyz')

[Kushal_Chawda · Accepted solution]

try

= mid(FieldName,2)

[#4]

what is this 'abcdefghijklmnopqrstuvwxyz'

In my case, i just want to remove the first word

[Colin-Albert]

Hi Chanty,

keepchar([FieldName],'abcdefghijklmnopqrstuvwxyz')

will not work as this will remove all numeric and uppercase characters leaving lowercase characters only- all data in Qlik is case sensitive.

tT exclude the first character, use mid()

mid(FieldName, 2) will return everything in the field from the 2nd character.