How to duplicate the column and replace G with missing value ?

[admin11]

Hi All
I have the field name = GROUP_TYPE , It have G1 , G2 ...... 

I like to create another column , that is copy all the value label except "G"

So it will return as below :-

G1...G1

G2...G2

G..........

G will replace with missing value.

Can some one share with me the expression ?

Paul

[Anonymous · Accepted solution]

Hello

G is the minimum LEN =1

if(Len(Groupp_Type)>1,Group Type)

[admin11]

@Anonymous 

Thank you very much. it work

Paul