Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
keepchar([
FieldName],'abcdefghijklmnopqrstuvwxyz')
try
= mid(FieldName,2)
what is this 'abcdefghijklmnopqrstuvwxyz'
In my case, i just want to remove the first word
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.