Skip to Content
0
May 02, 2018 at 06:36 PM

Make a word to move one backspace forward?

82 Views

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?