I am trying to convert to replace space in my row data with null in SSIS Script task.
And Because of which the spaces between my Date and Time (YYYY-MM-DD HH:MM:SS) as getting replaced also to YYYY-MM-DDHH:MM:SS

Is there a way to find this particular pattern in my row data and add a space using regex ?

so far what i have done

Dim filePath As String = Dts.Varaibles("User::FullFilePath").Value.ToString();
File.WriteAllText(filePath, File.ReadAllText(filePath).Replace(" ", ""));

string pattern = "-[0-9][0-9][0-9][0-9]:";
File.WriteAllText(filePath, File.ReadAllText(filePath).Regex.Replace(pattern, " "));

And this is replacing the Date and Hour values with ” ” like YYYY-MM MM:SS

Kindly help.

Thanks,