Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

remove first character if it is a 2

I would like to remove the first character if it is a 2.   Thanks in advance
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous  Try this as a New Column

     

    NewData = IF(LEFT([Data],1)="2",MID([Data],2,LEN([Data])-1),[Data])
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous  Try this as a New Column

 

NewData = IF(LEFT([Data],1)="2",MID([Data],2,LEN([Data])-1),[Data])
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Worked perfect.  Thanks for your help

  • sdhn's avatar
    sdhn
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

    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