select replace substring substring_index 'aaa bbbb ccccc' ' ' 3 length substring_index 'aaa bbbb ccccc' ' ' 3 1 + 1 ' ' '' ITEM3 The above formula does not need the first item to be handled as a special case and returns empty strings correctly when the ...