Logic is not clear to me but assuming is something like building rows taking specific columns from different text file lines I would suggest to define the text file as an "external table" then write a query that does what is needed.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
If you feel adventurous you can use some combination of the following to merge the line back into a delimited format: sed, awk, cut, grep.
Where I was working before I wrote some SQL to reformat the outout of openLDAP used to store connect strings into a colon delimited format. It worked but it was damn ugly!!!
Logic is not clear to me but assuming is something like building rows taking specific columns from different text file lines I would suggest to define the text file as an "external table" then write a query that does what is needed.
PAVB your right, make it a external table it should come out the best
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Originally Posted by PAVB
Bookmarks