Dropping text from a string

[#1]

Hi ... I want to load the below field, 'SALES_NUMBER', but excluding the string 'AB' wherever it exists.

222100

223190

AB224190

AB225190

So output should be :

222100

223190

224190

225190

[sunny_talwar · Accepted solution]

Try

KeepChar(SALES_NUMBER, '0123456789') as SALES_NUMBER

KeepChar() is the function, misspelled it intially

[arulsettu]

if you want only numbers try this

keepchar(SALES_NUMBER,'0123456789')

[Anonymous]

use KeepChar() instead of KeepChart() as suggested by Sunny

[sunny_talwar]

Hahahaha I don't see KeepChart()

Just kidding, I saw my mistake and fixed it

[Anonymous]

or try like this at script level, if it is in fixed format:

if(istext(mid(SalesField),1,2), mid(SalesField,3,len(SalesField)), SalesField) as SalesField

[robert_mika]

OR

PurgeChar('AB224190','AB')

Feeling Qlikngry?

How To /Missing Manual(23 articles)

[Anonymous]

I was also kidding, Becoz I knew that before putting my comment for you, you would have been updated that

[its_anandrjs]

Try this way also

LOAD *,PurgeChar(COLA,'ABCDEFGHIJKLMNOPQRSTUVWXYZ') AS KleenField;

LOAD * Inline

[

COLA

222100

223190

AB224190

AB225190

];

Regards

Anand

[#10]

Thank you all. I used the first solution ie the keepchar function and it worked nicely.

What if now however I only wanted to pick up values which included the AB string ? So my output would return only the following :

AB224190

AB225190