Forum Discussion
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...
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
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
This is working, thank you PhilipTreacy