Apparently I do a ctrl-c with data selected in the grids a lot, so I’ve had a chance to see how this works.
I love the fact that I can get the strings quoted. I often select a subset of data from a single column and then put it into an IN statement. I’ve had to create a find/replace macro to change those values to quote comma separated. With the dialog, I can now get the quotes, but I can’t get the commas. So it would be great to have an option to add a delimiter at the end of the lines as opposed to a field delimiter (which is not used if there is a single column). Or a new export format option for an IN statement that already does that for me.
I also find that I use different options depending on which export format I select or whether I enter this dialog from a Ctrl-C or the right-click Export Grid Contents. When I’m selecting a single column for an IN statement, I generally don’t want the headers, but if I’m exporting to Excel I do.
I especially appreciate the fact that this always defaults to Delimited Text, despite whatever I last exported as. Though if you add the IN option, I can almost guarantee that I would want that to be my default export format. Is it possible to allow the user to set the default they want to use for this dialog?
Thanks for the upgrade on this. My quality of life has just improved yet again thanks for Toad.
Digital Products & Strategies, Cru | Data Sciences & Analytics