Forum Discussion

kangkopi15's avatar
kangkopi15
Helper I
2 years ago
Solved

New simplify new column from another column

Dear Experts, I need your help again, I have this table called Grade with all the details, and I want to create a new column called Grade Final with general details, by referring to the previous colu...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    Hi kangkopi15 

     

    Your example data is different to your actual data in that the actual data has some grades that do not contain ().

     

    try this instead

     

    Grade Final = 

VAR _Bracket = SEARCH("(", [Grade], ,0)

RETURN

IF (_Bracket > 0 , "Grade " & MID([Grade], _Bracket +1,1), "Grade " & MID([Grade], LEN([Grade]),1))

     

    regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

Hi kangkopi15 

 

Create the new column with this

 

Grade Final = "Grade " & MID([Grade], FIND("(", [Grade])+1,1)

 

Regards

 

Phil

  • kangkopi15's avatar
    kangkopi15
    Helper I
    2 years ago

    Hi PhilipTreacy I tried to use the formula in the actual table, but unfortunately it doesn't work

    I suppose to have Band 3, Band 3, Band 2 and so on under Band column