topic String Column Value Formatting in QlikView

String Column Value Formatting

Fri, 11 Feb 2011 22:02:18 GMT

Hi,

I have a column as in which values are coming like

AX0198

AX 023487

FEWEUYU

SDERV*

AXRTYU*

If column values start with 'AX' or/and ends with * then I want to remove 'AX' and * from the values.

Thanks,

Lico

Fri, 11 Feb 2011 23:03:09 GMT

Hi Lico,

Try this formula, instead of AX0198 just put the column name.

if(Left('AX0198',2)='AX' or Right('AX0198',1) = '*', mid('AX0198',3,len('AX0198')-1))

Hope it helps

Tue, 15 Feb 2011 16:02:45 GMT

That definitly helped...Thank you. I had to use else_expr part of IF function in order to get the right result.