String Column Value Formatting

[#1]

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

[#2 · Accepted solution]

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

[#3]

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