Solved: Need help regarding MID function

D_J · ‎09-13-2023

Why i am getting error in this , could anyone please help

nirali_arora · ‎09-14-2023

Mid don't take '0' so please handle the case using the following formula

Column = var _yo = SEARCH("yo",[City],,0)*1

var _mid = if(_yo>0, MID([City],_yo,1),BLANK())

return _mid

nirali_arora · ‎09-14-2023

Mid don't take '0' so please handle the case using the following formula

Column = var _yo = SEARCH("yo",[City],,0)*1

var _mid = if(_yo>0, MID([City],_yo,1),BLANK())

return _mid

Need help regarding MID function