I have a rather big flat file that I need to import into a SQL server. The issue I am having is that I need to make the word "From" to move one backspace forward so that the line that starts with the word is lined up with the previous line.
From:
F;170027833;16040;P;CAD47;03/07/201704:11:12;11;1; FromProQA:Descr:DIZZYPatCnt:1Age:22Year
To:
F;170027833;16040;P;CAD47;03/07/201704:11:12;11;1;FromProQA:Descr:DIZZYPatCnt:1Age:22Year
If there were just a few of these, then I could do this manually, but there are a lot of these. The file is currently in text file format.
Help, please?