remove first character if it is a 2

[Anonymous]

I would like to remove the first character if it is a 2.

Thanks in advance

[PattemManohar · Accepted solution]

@Anonymous  Try this as a New Column

NewData = IF(LEFT([Data],1)="2",MID([Data],2,LEN([Data])-1),[Data])

[sdhn]

I have table called Dept.  I have one column called Departments 

Deaprtments values started from ABC_

I want to remove ABC_ from all department values.  

Do I need to create new mneasure on Departments or New Column?  I tried both but not successful yet.  Thanks 

Thanks 

[Anonymous]

Worked perfect.  Thanks for your help