Hello!
It would be quite usefull for me to be able to save result of SQL SELECT statement into parametrised TXT file. I want to be able select string delimiter of fields (tab, comma, semicolon, space) or fixed width of column and text qualifier (quotes). What about this? I am using SQuirreL 2.2 final.
Thank You. Stepan

Thread view

Hello!
It would be quite usefull for me to be able to save result of SQL SELECT statement into parametrised TXT file. I want to be able select string delimiter of fields (tab, comma, semicolon, space) or fixed width of column and text qualifier (quotes). What about this? I am using SQuirreL 2.2 final.
Thank You. Stepan

Hi Stepan,
another user already asked for this feature not long ago. I'll see if I can get
it in to 2.3. For the moment all I can offer is to copy and paste the result.
The delimiter will then be a tab character.
Gerd
Stepan RYBAR wrote:
> Hello!
>
> It would be quite usefull for me to be able to save result of SQL SELECT statement into parametrised TXT file. I want to be able select string delimiter of fields (tab, comma, semicolon, space) or fixed width of column and text qualifier (quotes). What about this? I am using SQuirreL 2.2 final.
>
> Thank You. Stepan
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Gerd,
I was thinking little bit more about requested feature and I do not nee=
d really fixed width of columns. And not only because it can be more co=
mplicated to implement it comparing to tab, space, semicolon... delimit=
er.
Stepan
< ------------ P=F9vodn=ED zpr=E1va ------------
< Od: Gerd Wagner <birgit-und-gerd@...>
< another user already asked for this feature not long ago. I'll see i=
f I can get
< it in to 2.3. For the moment all I can offer is to copy and paste th=
e result.
< The delimiter will then be a tab character.
<
< Stepan RYBAR wrote:
< > It would be quite usefull for me to be able to save result of SQL =
SELECT
< statement into parametrised TXT file. I want to be able select strin=
g delimiter
< of fields (tab, comma, semicolon, space) or fixed width of column an=
d text
< qualifier (quotes). What about this? I am using SQuirreL 2.2 final.

Stepan,
thanks for your hint. I'll see how much extra coding fixed sizes will take. If
it's much I'll skip it.
Gerd
Stepan RYBAR wrote:
> Gerd,
> I was thinking little bit more about requested feature and I do not need
> really fixed width of columns. And not only because it can be more
> complicated to implement it comparing to tab, space, semicolon...
> delimiter.
> Stepan
>
> < ------------ Původní zpráva ------------
> < Od: Gerd Wagner <birgit-und-gerd@...>
> < another user already asked for this feature not long ago. I'll see if
> I can get
> < it in to 2.3. For the moment all I can offer is to copy and paste the
> result. < The delimiter will then be a tab character.
> < < Stepan RYBAR wrote:
> < > It would be quite usefull for me to be able to save result of SQL
> SELECT
> < statement into parametrised TXT file. I want to be able select string
> delimiter
> < of fields (tab, comma, semicolon, space) or fixed width of column and
> text
> < qualifier (quotes). What about this? I am using SQuirreL 2.2 final.
>

Stepan RYBAR wrote:
> Gerd,
> I was thinking little bit more about requested feature and I do not need
> really fixed width of columns. And not only because it can be more
> complicated to implement it comparing to tab, space, semicolon...
> delimiter.
Is available in CVS. See change log for further details. As you suggested I left
out fixed column widths.
Gerd
> Stepan
>
> < ------------ Původní zpráva ------------
> < Od: Gerd Wagner <birgit-und-gerd@...>
> < another user already asked for this feature not long ago. I'll see if
> I can get
> < it in to 2.3. For the moment all I can offer is to copy and paste the
> result. < The delimiter will then be a tab character.
> < < Stepan RYBAR wrote:
> < > It would be quite usefull for me to be able to save result of SQL
> SELECT
> < statement into parametrised TXT file. I want to be able select string
> delimiter
> < of fields (tab, comma, semicolon, space) or fixed width of column and
> text
> < qualifier (quotes). What about this? I am using SQuirreL 2.2 final.
>