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])

3 Replies

  • 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