allan IS Working
Guppy
Hey all,
I have a very basic question about how to SQL query data from a .txt file. I use both UltraEdit and Toad, but for this task I need to go through a massive text file and find all lines that contain a date between October 1st, 2008 and today. The date is in MMDDYY format and is located in positions 127 to 132.
My biggest road block right now is knowing how to SQL a text file. I know how to SQL database tables, but I have never done this.
Any ideas?
Thanks!
I have a very basic question about how to SQL query data from a .txt file. I use both UltraEdit and Toad, but for this task I need to go through a massive text file and find all lines that contain a date between October 1st, 2008 and today. The date is in MMDDYY format and is located in positions 127 to 132.
My biggest road block right now is knowing how to SQL a text file. I know how to SQL database tables, but I have never done this.
Any ideas?
Thanks!
