How to remove values starts with * for a field in qliksense

[DS14]

Hi Experts,

I have the data in below format.

Field0_Pers.area	Field1_Name of EE subgroup	Month	Value
* PA00		Field2_Mar-18 No	14
* PA0X		Field2_Mar-18 No	13
* PA01		Field2_Mar-18 No	39
* PA02		Field2_Mar-18 No	159
* PA03		Field2_Mar-18 No	41
* PA05		Field2_Mar-18 No	0
* PA06		Field2_Mar-18 No	32
* PA07		Field2_Mar-18 No	29
* PA08		Field2_Mar-18 No	38
* PA09		Field2_Mar-18 No	209
* PA10		Field2_Mar-18 No	52
* PA12		Field2_Mar-18 No	14

I need to remove all values for the field Field0_Pers.area  which starts with the *.

[miskinmaz]

Hi,
You can try PurgeChar ( Field0_Pers.area,'*' )

[JordyWegman]

Hi Deepaksingh,

Is the field always in this condition? If the answer is yes, use the most simplest version: 

Right(Field0_Pers.area,4)

If your field PAXXX varies in length use:

Right(Field0_Pers.area,Len(Field0_Pers.area)-2))

Otherwise use:

KeepChar(Field0_Pers.area,'abcdefghijklmnopqrstuvwxyz1234567890')

Jordy

Climber

[jonathandienst · Accepted solution]

Do you want to remove the "*" prefix from the field value:

PurgeChar(Field0_Pers.area, '*')

Or do you want to exclude the records where there is "*" prefix:

LOAD Field0_Pers.area,
....
From ....
Where Left(Field0_Pers.area, 1) <> '*';

[DS14]

Thanks  a  lot Jontydkpi.