I'm currently working on finding a solution to strip/edit a texfile in order to pass it through to Oracle's SQLLOADER which in turn will import the data into a table.
The textfile will need to be imported into a clob column inside the first table after which the imported data will need to be placed in the proper columns but unfortunately I haven't got a clue as to how I need to start but I think Python is my best bet...
The textfile looks like the first attachment.
Now, what I don't need from the textfile is the header and the last part of the textfile starting from "Summary for fw0204.txt".
What I do need in my database import file is the first part of the textfile containing the 'sort of' columns but is a bit distorted with spaces etc...
It should look like this when 'the' script is done with it and it can be passed on to an sqlloader import file:
The output file needs to look like the last attachment
How do I create a python script to use the above data from the textfile into an inputfile for sqlloader?
You help will be much appreciated, thanks in advance!