Using a script task or by using a regular expression, is there a way in SSIS that I can parse a flat file, have it find places where there are missing column delimiters and fix them?
A file with - column delimiter | (pipe) and text qualifier " (double-quote) may come across a value like
|"1"2.5"| which should be |"1"|"2.5"| (an |" was added).
I also realize that I could use the REPLACE function within a Derived Column Task to do the same thing but I am unable to figure out the correct function that I would use.
Go someone get me started?