Toad World® Forums

Query Builder Load From File error

I need to load a list from a file for an IN condition. When I load these values the Query builder adds multiple sets of single quotes. Can we get this fixed? I need to load a pretty long list of values.

And to make it worse, when I edit out the extra quotes I have to use the visualize button and that puts everything into a Global Where Clause (which I am trying to avoid.....)

If you are pulling the list from a CVS/or spreadsheet, I can give you a workaround. Grab Notepad++ (windows). Copy the column with the data, paste it into a blank Notepad++ doc. Then do a find and replace using Find What: \r\n Replace: ',' Use "Replace All"

Capture

That will give you a list like this:
1234','2345','3456','4567

Just add the single quote to the beginning and end of your line. Not an ideal solution, but it will let you move forward.

Hi - I tried to recreate but was not able to - can you share the text file you are trying to use?