should help you out What you want is to update your column values with a concatenation of the first part of the name followed by the space ' ', followed by the rest of the name.
SET name = CONCAT(SUBSTRING(name, 1, 5),
Insert space in a string at 8th column using sed
By : eng
Date : March 29 2020, 07:55 AM
help you fix your problem I know you asked for a sed solution but when you're talking about modifying specific field numbers you should really consider awk since it has built in support for numbered fields: