Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

exclude first word from column

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

1 Solution

Accepted Solutions

Re: exclude first word from column

try

= mid(FieldName,2)

4 Replies
Chanty4u
Esteemed Contributor III

Re: exclude first word from column

try this

keepchar([

FieldName],'abcdefghijklmnopqrstuvwxyz')

Re: exclude first word from column

try

= mid(FieldName,2)

Not applicable

Re: exclude first word from column

what is this 'abcdefghijklmnopqrstuvwxyz'


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

Re: exclude first word from column

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.

Community Browser