If there is a column with location. all locations starts with " SL. " now i want to remove this SL. but the thing is some of them dont have this so the right and mid comand is actualy cutting the first 3 letter so anything we can do for only selcting SL. and deleting the SL. only from SL.Mumbai and etc.
Latur Here Lat is cutted if right or mid is used
Solved! Go to Solution.
Try using Index
if (Index( FIELDNAME,'SL.') = 1 ,ETC
or replace might work
replace(fieldname , 'SL.','')
you might need trim (replace(fieldname , 'SL.',' ') )
replace(fieldname , 'SL.',null())